Hopefully you're not still having this problem. I don't use phpMyAdmin, but I know that it allows you to run "repair table" to try to fix a table after a crash. Does that work?
-Sheeri On 6/25/06, Khaled Jouda <[EMAIL PROTECTED]> wrote:
Hello, I am having a problem with one of my MySQL databases, the server was crashed, and then all InnoDB tables seem to be empty, when I click any innoDB table name in PhpMyAdmin i get the following error: #1016 - Can't open file: 'forums.ibd' (errno: 1) when I click the database name, I get a list of the tables, where PhpMyAdmin writes "in use" under the following columns: Records,Type,Collation, and size Do you have any idea why such a thing happens, and what can be done to restore the database? thanks Khaled
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
