Have you ever been asked to convert all of the tables in a given
database or on a server to a new storage engine? Well, we have!
Sometimes, if it is only a few tables, firing off a few "ALTER
TABLE ... ENGINE=InnoDB;" is fine. Other times, it is a nightmare
if there are lots of tables and/or databases.
To make our life easier in such times, we created the following Bash script. Save the file as something like "convert_tables.sh" and make sure to make it executable. You can do this in Linux by executing "chmod a+x ./convert_tables.sh." Take a look at the code and we will give you an example of how to run it!