GNU Info

(mysql.info)Adding and removing

---

Next: Backing up Prev: Using InnoDB tables Up: InnoDB

---

Enter node , (file) or (file)node

Adding and removing InnoDB data and log files
---------------------------------------------

You cannot increase the size of an InnoDB data file. To add more into
your tablespace you have to add a new data file. To do this you have to
shut down your MySQL database, edit the `my.cnf' file, adding a new
file to `innodb_data_file_path', and then start MySQL again.

Currently you cannot remove a data file from InnoDB. To decrease the
size of your database you have to use `mysqldump' to dump all your
tables, create a new database, and import your tables to the new
database.

If you want to change the number or the size of your InnoDB log files,
you have to shut down MySQL and make sure that it shuts down without
errors.  Then copy the old log files into a safe place just in case
something went wrong in the shutdown and you will need them to recover
the database. Delete then the old log files from the log file directory,
edit `my.cnf', and start MySQL again. InnoDB will tell you at the
startup that it is creating new log files.