Monday, December 3, 2012

Convert all tables to myisam -- mysql linux

Backup software like Zmanda recommends all  database to be either Myisam or Innodb.
For older versions of mysql MyISAM is faster.
Having innodb and myisam will need to allocate resources for both in my.cnf
So its better to have myisam only..

Howto convert all innodb to myisam ?

Imp:  Make backup of DB before attempting

Step 1:

Delete all foreign key constraints . We dont need them in myisam.