Jump to content


Recommended Posts

The easiest way I know of involves dumping the tables into a .sql file, editing the ENGINE line for each table definition, and reimporting. The following commands should work well for that (requires shell access to whatever server the db is on):

mysqldump --add-drop-tables -udb_username -p db_name > dump.sql
sed 's/^) ENGINE=InnoDB/) ENGINE=MyISAM/g' dump.sql > dump.sql.2
less dump.sql.2 (to verify that everything looks right)
mysql -Ddb_name -udb_user -p < dump.sql.2

In the event of your board breaking after the last one, this will restore your database to how it was before your started
mysql -Ddb_name -udb_user -p < dump.sql
The above code, while I verified that the sed command and such works, is however unvetted on a live site. I recommend doing this on a test install and verifying everything is still working (and that reimporting the db backup in case it gets messed up) all work before running this on a production site.
Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...