Some time you can't repair table using repair command.It will show error like "Can’t create new tempfile: ‘*.TMD file" .So we have to recover that table particular table or all tables of database.
For that you have to use the following command to do:
First go to the library file path of Mysql
myisamchk -r -f *.MYI
For that you have to use the following command to do:
First go to the library file path of Mysql
/var/lib/mysql/Particular_db_name:
1.For single table recover
myisamchk -r -f TABLENAME.MYI
2.For ALL table recove
myisamchk -r -f *.MYI
No comments:
Post a Comment