Advanced Search

Return to Snippet

Revision: 3559
at August 13, 2007 01:13 by benpjohnson
Initial Code 
myisamchk -s $(find /var/lib/mysql/ -name *.MYI)

/etc/rc.d/init.d/mysqld stop

And this to fix the tables that need repairing: 

myisamchk -r -q <PATH>/table_name.MYI
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
Useful when your server runs out of disk space

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Fix MySQL Table problems

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
mysql

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
Bash