Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- MySql ibdata1 compact space
May 26, 2006, 9:08 am
rate this thread
Re: MySql ibdata1 compact 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.
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum