"I'm facing this situation to convert a table from MyISAM to InnoDB, no structure changes. Since I have enough space for both tables on disk, I'm thinking that the following procedure might save some time:
1. Create the new table w/…"
"... and if you drop indexes before the data load and recreate them after it's finished, chances are it'll be even faster. Not to mention that you can do the same using mysqldump with the right options to dump a single table. Then edit the…"
"Depending on the server, you may want to avoid leaving credentials in the ".bash_history". Do the following:
1. Create a file for each host (host_cred for the current examples) with the lines:
2. chmod the…"