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
- Access the server's command line as the 'root' user via SSH or "Terminal" in WHM.
- 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. - 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.
Comments
0 comments
Article is closed for comments.