424,303 Members | 1,366 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,303 IT Pros & Developers. It's quick & easy.

MySql ibdata1 compact space

P: n/a
Hello I have a problem with mysql.

Using the tables of type INNODB, mysql it has created the archives
(ibdata1) whose dimensions exceed the 3G.

I have cancelled all the database but the occupied space is remained
the same one. How I can make in order to compattare this space?

Thanks

May 26 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
be******@esact.it wrote:
Hello I have a problem with mysql.

Using the tables of type INNODB, mysql it has created the archives
(ibdata1) whose dimensions exceed the 3G.

I have cancelled all the database but the occupied space is remained
the same one. How I can make in order to compattare this space?


If you've dropped all the InnoDB tables, you can stop the MySQL Server,
manually delete ibdata1 and the InnoDB log files, and then restart MySQL
Server. MySQL Server will recreate a smaller ibdata1 file when it restarts.

If you have any InnoDB tables you want to keep, you must back them up
first with mysqldump, drop them, and restore them afterward.

See http://bugs.mysql.com/bug.php?id=1287

Regards,
Bill K.
May 26 '06 #2

P: n/a
Thanks for the answer

May 29 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.