I am using mysql-server-5.0.22-22.214.171.124 on centos 5.2 linux for asterisk version 1.2.27 database.
When I try to backup the database asterisk , it does not dump and give the following error message.
Kindly help in this regard,
# mysqldump -u root -p asterisk > backupname.sql Enter password: mysqldump: Got error: 1146: Table 'asterisk.vicidial_list_temp' doesn't exist when using LOCK TABLES
I found the following info my mysql log file
090302 3:36:09090302 3:36:09 [ERROR] Cannot find table asterisk/vicidial_list_temp from the internal data dictionary of InnoDB though the .frm file for the table exists. Maybe you have deleted and recreated InnoDB data files but have forgotten to delete the corresponding .frm files of InnoDB tables, or you have moved .frm files to another database? See http://dev.mysql.com/doc/refman/5.0/en/innodb-troubleshooting.html how you can resolve the problem.