How to convert MyISAM to InnoDB on Directadmin panel

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
wget http://files1.directadmin.com/services/all/mysql/restore_sql_files.sh
chmod 755 restore_sql_files.sh
./restore_sql_files.sh
service mysqld restart

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