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;
- Go to root access via putty tool
- 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.