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.
@@ Line 12: / Line 16: @@
 Example: Changing MyISAM tables to InnoDB
 \\
-\\Note: Change 'db_name' to the database you wish to change the engine of
+\\
+**Note**: Change 'db_name' to the database you wish to change the engine of
 <sxh bash>
 SET @DATABASE_NAME = 'db_name';