MySQL Forums
Forum List  »  InnoDB

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

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

Options: ReplyQuote


Subject
Views
Written By
Posted
13043
January 09, 2006 05:55AM
5523
January 11, 2006 08:51AM
5558
January 17, 2006 02:15AM
Re: ibdata1 Size Issue
6251
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.