Given a database with MyISAM tables, that one does not want to take offline
for more than is absolutely necessary, what's the quickest (in terms of
offline time) way to convert those tables to InnoDB?
The database I'm contemplating doing this on takes about 6 hours to load
into InnoDB tables from a mysqldump dump.
Is there anything faster/better than this method?
1. Get a snapshot of the database with mysqldump. Note the position in the
2. For each table foo, create an InnoDB table, new_foo, and restore new_foo
from the snapshot of foo.
3. Stop clients from ...