MySQL Forums
Forum List  »  InnoDB

Re: Resizing innoDB datafile
Posted by: Ryan Lowe
Date: January 13, 2009 09:05PM

In order to ensure that this doesn't happen again, you should consider innodb-file-per-table. The steps to make the ibdata1 file smaller are as follows:

1) Stop writes to the server
2) Dump the data
3) drop all databases (except mysql)
4) stop mysqld
5) remove the innodb data and log files
6) start mysqld (the innodb tablespace should be automatically created)
7) Check the error logs for anything strange
8) import the data

-- Ryan Lowe

Options: ReplyQuote


Subject
Views
Written By
Posted
6257
January 13, 2009 12:56AM
Re: Resizing innoDB datafile
3031
January 13, 2009 09:05PM
2862
January 14, 2009 03:36AM
2382
January 15, 2009 01:18AM


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.