'Refactoring' Tag

• Getting rid of huge ibdata file, no dump required, part II

  May 30, 2012

  This post continues Getting rid of huge ibdata file, no dump required, part I, where I describe way of converting your single-tablespace InnoDB database into a file-per-table one, without the pain of exporting and importing everything at once. In previous part we put aside the issue of foreign keys. We address this issue now. What [...]

  posted in MySQL by shlomi

• Getting rid of huge ibdata file, no dump required

  May 22, 2012

  You have been told (guilty as charged), that the only way to get rid of the huge InnoDB tablespace file (commonly named ibdata1), when moving to innodb_file_per_table, is to do a logical dump of your data, completely erase everything, then import the dump. To quickly reiterate, you can only delete the ibdata1 file when no [...]

  posted in MySQL by shlomi