If you want to convert your database tables to MyISAM then you can follow below steps.But for that it is must to have root access of your database.
You have to first dumped your SQL file via mysqldump and for that we have to replace "ENGINE=INNODB" with "ENGINE=MyISAM".
You can check below example:
After that you have to drop the database (user1_db) and recreate the database.
At last import the sql dump file.
You have to first dumped your SQL file via mysqldump and for that we have to replace "ENGINE=INNODB" with "ENGINE=MyISAM".
You can check below example:
Code:
mysqldump user1_db > user1_db.sql
sed -i 's/ENGINE\=InnoDB/ENGINE\=MyISAM/g' ./user1_db.sql
At last import the sql dump file.
Code:
mysql user1_db < ./user1_db.sql