PDA

View Full Version : mysqldump: Got error: 1033



massive
11-14-2009, 07:39 AM
When trying to backup all users i am getting the following output :

mysqldump error output: mysqldump: Got error: 1033: Incorrect information in file: './admin_db/example.frm' when using LOCK TABLES

Any idea why?

scsi
11-15-2009, 06:19 PM
Table might be damaged I would login as the admin user and go to user level then to mysql management then select that database and click the repair button at the bottom.

massive
11-16-2009, 12:55 AM
Thanks for your reply scsi.
I did that from phpmyadmin but the problem was the same.

I rememberd that i have made some (untested) changes in my.cnf
I rolled them backup,restarted mysql and now everythink seems ok.