MySQL Forums
Forum List  »  InnoDB

Re: ibdata1 Size Issue
Posted by: Heikki Tuuri
Date: January 20, 2006 09:54AM


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

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,

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

Options: ReplyQuote

Written By
January 09, 2006 05:55AM
January 11, 2006 08:51AM
January 17, 2006 02:15AM
Re: ibdata1 Size Issue
January 20, 2006 09:54AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.