IAMEM Hosting

Convert Existing MySQL Database to Innodb

Home > Blog > cPanel > Convert Existing MySQL Database to Innodb
20Mar, 2018
0

Convert Existing MySQL Database to Innodb

 

Converting existing MySQL Database Tables from MyISAM to InnoDB can be done from PHPMyAdmin but if there are too many tables the following script may help you to convert all the tables of a particular database to InnoDB

Pre-requisites:

1. This tutorial assumes that you have .my.cnf configured with MySQL credentials for auto-login
2. You have full privileges over the Database that you are trying to convert.
3. Take a backup of the database so that you can restore when things go wrong.

How to:

1. Create a file convert_innodb.sh with the below code

#!/bin/bash

DATABASENAME="database_name"

for t in `echo "show tables" | mysql --batch --skip-column-names $DATABASENAME`; do mysql $DATABASENAME -e "ALTER TABLE \`$t\` ENGINE = InnoDB;"; done

 

2. Give execute permission for the script

chmod 755 convert_innodb.sh

 

3. Execute the script using

./convert_innodb.sh

 

 

Leave a Reply

10 − 7 =

Copyright © 2019 | iamemhost.com . All rights reserved.