470,647 Members | 1,188 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,647 developers. It's quick & easy.

MySql ibdata1 compact space

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
2 12844
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
Thanks for the answer

May 29 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Asif Iqbal | last post: by
39 posts views Thread by Mairhtin O'Feannag | last post: by
2 posts views Thread by fuzzybr80 | last post: by
7 posts views Thread by Randy | last post: by
reply views Thread by support1 | last post: by
1 post views Thread by Korara | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.