Hi,
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! 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 very sparse on that.
Regards
Marten
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]