How to convert MyISAM to InnoDB on Directadmin panel, pub-5413329544040947, RESELLER, f08c47fec0942fa0

It is very important for webmasters to change traditional database tables MyISAM to InnoDB in MYSQL for MariaDB engine to keep the web data running faster.

This tip only works for VPS, Cloud and dedicated hosting where by the owner has root access to server.

Here are the steps to follow;

  1. Go to root access via putty tool
  2. Then paste the following code the n place enter button to execute the command;
cd /usr/local/directadmin/custombuild
./build set mysql_backup yes
./build mysql_backup
mv mysql_backups mysql_backups.`date +%F`
./build mysql_backup
cd mysql_backups
perl -pi -e 's/ENGINE=MyISAM/ENGINE=InnoDB/' *.sql
chmod 755
service mysqld restart

3. Everything done, all database tables will be set to InnoDB.

Be the first to comment

Leave a Reply

Your email address will not be published.


This site uses Akismet to reduce spam. Learn how your comment data is processed.