Re: ibdata1 Size Issue

[Heikki Tuuri]

Hi!

Here is advice about how you recreate the InnoDB installation from scratch:

http://dev.mysql.com/doc/refman/5.0/en/error-creating-innodb.html

1) Dump all your InnoDB tables.

2) Shut down mysqld.

3) Delete the .ibd and .frm files of all your InnoDB tables (or you may have used DROP TABLE to them), delete your ibdata files and ib_logfiles.

4) Edit my.cnf to suit you better.

5) Restart mysqld.

6) Import the table dumps.

Best regards,

Heikki
Oracle Corp./Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL

InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables
http://www.innodb.com/order.php