Differences

This shows you the differences between two versions of the page.

--- mysql_storageengine [2016/02/05 14:46] – luke7858
+++ mysql_storageengine [2024/05/23 07:26] (current) – external edit 127.0.0.1
@@ Line 3: / Line 3: @@
 \\
 mysql < 5.5 the default engine is MyISAM
+\\
+\\
 Before we convert tables we can first view the table engine with:
+\\
+**Note**: Change 'db_name' to your database
 <sxh bash>
+SELECT TABLE_NAME, ENGINE FROM information_schema.TABLES where TABLE_SCHEMA = 'db_engine';
 </sxh>
 Now we have viewed the table engine we can go ahead and convert the tables.
 \\
 \\
-Example: Changing MyISAM tables to InnoDB:
+Example: Changing MyISAM tables to InnoDB
+\\
+\\
+**Note**: Change 'db_name' to the database you wish to change the engine of
 <sxh bash>
-SET @DATABASE_NAME = 'table_engine';
+SET @DATABASE_NAME = 'db_name';
 SELECT  CONCAT('ALTER TABLE `', table_name, '` ENGINE=InnoDB;') AS sql_statements