Christian M. Posted February 24, 2013 Posted February 24, 2013 how do you go about converting InnoDB to myISAM?
skizzerz Posted February 24, 2013 Posted February 24, 2013 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.
Christian M. Posted February 24, 2013 Author Posted February 24, 2013 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.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.