buycpanel-resources-banner

Resources

If you can’t find the answer you are looking for please submit a ticket.
We are here to help 24/7/365!

INNODB to MYISAM
Posted by – NA – on 28 December 2010 09:44 AM
If you need to transfer your database which is INNODB format to another server which engine is MYISAM suppose test.sql is your database You can check which Engine it is using by running the following command

# head -50 test.sql –> there you can see innodb or MYISAM

Our requirement is to restore the database to MYISAM however our server is supporting MYISAM. So we need to edit /etc/my.cnf line

#skip-innodb to skip-innodb

Then execute the following perl script to change all Innodb terms in test.sql to MyISAM

perl -p -i -e “s/Innodb/MyISAM/” test.sql

Then restore the database

In some cases, database may be created by executing the commands in the dump file (for example if .sql file contains create database databasename) So inorder to restore the dump just execute

mysql < test.sql