So you’ve got a mysql server with an unknown number of isam tables and you need to convert them (the easy way)? Here’s how:
find /var/lib/mysql/ -name “*.ISM” -print > convert.txt
emacs convert.txt
replace: “/var/lib/mysql/” with “alter table “
replace “.ISM” with ” type = myisam;”
replace “/” with “.”
Be careful to include the spaces where I have them.
The run:
mysql -u root -p < convert.txt
