I have an IBDATA1 file that has grown to 2gb even though all Innodb tables have been either converted to MyISAM or dropped. (There are no InnoDb tables left) My question is how to I decrease the size of the IBData file?
I tried shutting down the MySQL server and deleting the IBDATA1 file, then restart MySQL to rebuild the file. But MySQL has a problem of starting and no error is reported in MySQL.Err.
So is there a proper way of reducing the size of the filespace used by Innodb?
You can't do it except by recreating the tablespace with a smaller size. Use mysqldump to dump all InnoDB files. Then shut down the server cleanly, remove the tablespace and log files, and redefine the tablespace in your config file. Then restart the server, let it reinitialize the new (smaller) tablespace, and reload your dump file.
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
