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 Quote 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. Quote 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? Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.