Posted on February 21, 2023 by darshin

Convert MySQL(Myisam tables) to innoDB

1. Database location: /var/lib/mysql/xtream_iptvpro all tables should have two files .frm and .ibd
2. If there are any tables that do not have those files and instead have other types of files then note down the table names as they will be needed on the next steps.
3. Login to MySQL from CMD.
4. xtream_iptvpro – is an example of database name.
5. Swap table_name with your actual table.
6. Run the following:
   use database xtream_iptvpro;

ALTER TABLE table_name ENGINE=InnoDB;