Remove InnoDB Data Files

• A data file cannot be removed from the tablespace.

• To decrease the size of the tablespace, use this procedure:
  • Use mysqldump to dump all InnoDB tables.
  • Stop the server.
  • Remove all the existing tablespace files.
  • Configure a new tablespace.
  • Restart the server.
  • Import the dump files.

How do I make a binary backup consisting of all files used by InnoDB to manage its tables?

---

---

© 2007 John Michael Pierobon

Notes