Marten Lehmann wrote:
I had a lot of trouble today because the InnoDB integration in MySQL is lousy. I read the manual and worked with innodb_per_file_table. So when I shutdown mysql I should be able to delete ib_logfile0, ib_logfile1 and ibdata1, because all table-data should be stored in the .idb and .frm files. But this obviously is not the case!
The ib_logfile* stores, among other things, transaction history and whatnot. If you delete the log files or they otherwise become corrupted, your InnoDB tables spaces become unusable and you have to rebuild the table space.
MySQL always reports errors that it can't find the table files, although they are in the directory of the database. And additionally: If I'm removing the files from a databases and try to create a table that existed before (but now doesn't exist because the files are removed), I can't create it any more. What is the function of ib_logfile and ibdata? I expected them to store transaction data only, but the seem to store more. But documentation is
The ibdata file(s) contain the table data and indexes. You need both the ibdata file(s) and the iblog file(s). The table definitions are still stored in the .frm files.
At this point it sounds like you will need to delete the .frm files for the tables and recreate the innodb files.
Good luck. b. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]