Help on Shrink IBDATA1 file
This is a discussion on Help on Shrink IBDATA1 file within the MySQL forums, part of the Database Server Software category; --> How can I shrink the file IBDATA1 on MYSQL directory? I use windows 2003. Thanks a lot. Roberto...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 08:32 AM
| ||||
| ||||
 Re: Help on Shrink IBDATA1 file Roberto Rasto wrote: > How can I shrink the file IBDATA1 on MYSQL directory? > I use windows 2003. This is a common complaint about MySQL. The following is the only way to shrink the file: 1. Back up all databases that use InnoDB tables. 2. Drop all InnoDB tables. 3. Remove the IBDATA1 file manually. 4. Restore all InnoDB tables from your backups. This recreates the IBDATA1 file and fills it. This is very inconvenient, and it has been logged as a bug, but there is no other solution at this time. See discussion at http://bugs.mysql.com/bug.php?id=1341 Regards, Bill K.      |
Linear Mode
