I am using mysql-server-5.0.22-2.1.0.1 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.