brashquido Posted March 9, 2007 Share Posted March 9, 2007 Hi All, I have around 1100 tables on my MySQL server, and I'm wanting to convert them all so that they are using the MyISAM engine. Is there anyway I can convert all my tables in one statment? something like; ALTER TABLE * ENGINE = MYISAM Link to comment https://forums.phpfreaks.com/topic/41998-changing-table-engine-type-en-masse/ Share on other sites More sharing options...
fenway Posted March 9, 2007 Share Posted March 9, 2007 Nope... just run a SHOW TABLES, go to a text editor, and do a search & replace. Link to comment https://forums.phpfreaks.com/topic/41998-changing-table-engine-type-en-masse/#findComment-203787 Share on other sites More sharing options...
brashquido Posted March 9, 2007 Author Share Posted March 9, 2007 Ok, thanks. When I type in SHOW TABLES should I get a full list of all tables in all the databases? Link to comment https://forums.phpfreaks.com/topic/41998-changing-table-engine-type-en-masse/#findComment-203892 Share on other sites More sharing options...
fenway Posted March 11, 2007 Share Posted March 11, 2007 Well, only for the current database. Link to comment https://forums.phpfreaks.com/topic/41998-changing-table-engine-type-en-masse/#findComment-204562 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.