How to convert a database table from InnoDB to MyISAM

Introduction

When someone wants to convert a database table to MyISAM, the alter table SQL command can be used. This article provides the steps to convert a table.

Please note that a qualified server administrator should perform the conversion.

Procedure

1. Access the server's command line as the 'root' user via SSH or "Terminal" in WHM.
2. Backup the database.

   mysqldump $user_db > $user_db.sql

   Please note that "$user_db" must be replaced with the name of the database the table is in.
3. Run the following command to convert the table.

   mysql -e "alter table $user_db.$table_name ENGINE = MyISAM;"

   Please note that "$user_db" and "$table_name" must be replaced with the name of the database the table is in and the table name.