Hi! Running version 4.0 we created a fairly big innodb table (10GB, 72.950.601 rows).
After upgrading to 4.1.7 we switched to multiple tablespaces. Then somebody "ALTER"ed the table and innodb created a new idb file for the table. So right now we have 3 large files (old ibdata1|2 and the new *.ibd file). How can I get rid of the old main ibdata files? The documentation in 15.8 talks about deleting the file and recovering from a mysqldump. Is this still necessary, when I'm using multiple tablespaces? All the data would still be in the new .ibd file. Can anyone tell me, what would happen if I deleted the main ibdata1 file but left the .ibd intact? Would innodb recover gracefully? bye, Paul. -- Paul Mallach ARIVA.DE AG Ostseekai 2 D - 24103 Kiel Tel: +49 (0)431/97108-24 E-Mail: [EMAIL PROTECTED] Fax: +49 (0)431/97108-29 Internet: http://www.ariva.de -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
