ns0 mysql # tail -n 100 mysqld.err
071209 11:09:04 InnoDB error:
Cannot find table test/domains 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?
Look from section 15.1 of http://www.innodb.com/ibman.html
how you can resolve the problem.
071209 11:09:04 /usr/sbin/mysqld: Can't open file: 'domains.InnoDB'. (errno: 1)
ns0 mysql # mysql -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 12 to server version: 4.0.27
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use pdns;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> describe domains;
+-----------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+--------------+------+-----+---------+----------------+
| id | int(11) | | PRI | NULL | auto_increment |
| name | varchar(255) | | UNI | | |
| master | varchar(20) | YES | | NULL | |
| last_check | int(11) | YES | | NULL | |
| type | varchar(6) | | | | |
| notified_serial | int(11) | YES | | NULL | |
| account | varchar(40) | YES | | NULL | |
+-----------------+--------------+------+-----+---------+----------------+
7 rows in set (0.00 sec)