MyISAM to myISAM

[Christian M.]

how do you go about converting InnoDB to myISAM?

[skizzerz]

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.]

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.