R
rihad
Guest
Hi all,
After our database FS /var crashed on Debian 3.1 we had to pull its directory from backups (the only backup we had), including /var/lib/mysql/*. Despite chowning/chmodding everything thereunder for access by user mysql and starting the server successfully, the logs are full of messages like:
The said link no longer exists: http://www.innodb.com/ibman.html
There are several tables, not only misc.
How can I bring everything together? I hear the same thing happens when you simply stop the server, copy the directory containing ibdata1 somewhere else, and start the server. How to make it work again? Please somebody help, this is urgent...
Thanks.
After our database FS /var crashed on Debian 3.1 we had to pull its directory from backups (the only backup we had), including /var/lib/mysql/*. Despite chowning/chmodding everything thereunder for access by user mysql and starting the server successfully, the logs are full of messages like:
Jan 8 13:16:20 ns3 mysqld[1565]: 080108 13:16:20 [ERROR] /usr/sbin/mysqld: Can't open file: 'misc.ibd' (errno: 1)
Jan 8 13:16:20 ns3 mysqld[1565]: 080108 13:16:20 InnoDB error:
Jan 8 13:16:20 ns3 mysqld[1565]: Cannot find table psa/smtp_poplocks from the internal data dictionary
Jan 8 13:16:20 ns3 mysqld[1565]: of InnoDB though the .frm file for the table exists. Maybe you
Jan 8 13:16:20 ns3 mysqld[1565]: have deleted and recreated InnoDB data files but have forgotten
Jan 8 13:16:20 ns3 mysqld[1565]: to delete the corresponding .frm files of InnoDB tables, or you
Jan 8 13:16:20 ns3 mysqld[1565]: have moved .frm files to another database?
Jan 8 13:16:20 ns3 mysqld[1565]: Look from section 15.1 of http://www.innodb.com/ibman.html
Jan 8 13:16:20 ns3 mysqld[1565]: how you can resolve the problem.
The said link no longer exists: http://www.innodb.com/ibman.html
There are several tables, not only misc.
How can I bring everything together? I hear the same thing happens when you simply stop the server, copy the directory containing ibdata1 somewhere else, and start the server. How to make it work again? Please somebody help, this is urgent...
Thanks.