Knowledge Base

Allows you to search a variety of questions and answers

Search

Search results

MySQL

How can I efficiently change from innodb to myisam or vice versa?

To do this, you will need to stop your httpd server and then run the following script:
 

Code:

#/bin/bash
#script to convert the whole database to innodb format.
cp -iRfp /var/lib/mysql /var/lib/mysql-$(date +%s)
for mydatabase in $(mysql --batch --column-names=false -e "show databases");
do
for t in $(mysql --batch --column-names=false -e "show tables" $mydatabase);
do
mysql -e "alter table $t type=InnoDB" $mydbname;
echo "converted "$t" to innodb"
done
done

Save it to a file and then execute it. Just make sure to make a backup before hand. Replace 'InnoDB' with MyISAM if you want to switch to MyISAM. Also replace 'mydatabase' and 'mydbname' with the name of the actual database that you want this done to.

See What Our Customers Say

Partners
Stay Connected - Receive Exclusive Deals
We Securely Accept

© 2004 - 2024 AYKsolutions, LLC. All Rights Reserved.