February 24, 201312 yr 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.
February 24, 201312 yr Author your method worked, but i just exported the enitre database and then used notepasd ++ to change all notes of InnoDB to MyISAM thtx for helping.
Archived
This topic is now archived and is closed to further replies.