Entries Comments



Month: May, 2008

Moving a MediaWiki installation from InnoDB to MyISAM

5 May, 2008 (15:39) | mysql, web, wiki | By: agraf

  • Export the DB to sql statements.
  • Search-and-replace “InnoDB” with “MYISAM”.
  • Re-import the tables.  Might want to do this into a different DB than the old one, just in case.
  • Configure MediaWiki to use the new MyISAM DB.
  • Make sure the user MediaWiki is using to connect to MySQL will be able to access the new DB.

Bonus:

  • Put the “skip-innodb” line into the .my.cnf file.
  • Stop the DB.
  • Start the DB.

InnoDB is gone.  Yaaay.

detail:

bin/mysqldump -u root -p –lock-tables –add-drop-database DATABASE_NAME > DATABASE_NAME.sql

/rc22/d77/agraf/bin/rpl  ‘ENGINE=InnoDB’ ‘ENGINE=MyISAM’ DATABASE_NAME.sql

bin/mysql -u root -p DATABASE_NAME < DATABASE_NAME.sql

Comments: -