Decreasing the Size of the InnoDB
Tablespace
Currently, you cannot remove a data file from the tablespace. To decrease the size of your tablespace, use this procedure:
-
Use mysqldump to dump all your
InnoDB
tables. -
Stop the server.
-
Remove all the existing tablespace files, including the
ibdata
andib_log
files. If you want to keep a backup copy of the information, then copy all theib*
files to another location before the removing the files in your MySQL installation. -
Remove any
.frm
files forInnoDB
tables. -
Configure a new tablespace.
-
Restart the server.
-
Import the dump files.