Welcome to the Tweaking4All community forums!
When participating, please keep the Forum Rules in mind!
Topics for particular software or systems: Start your topic link with the name of the application or system.
For example “MacOS X – Your question“, or “MS Word – Your Tip or Trick“.
Please note that switching to another language when reading a post will not bring you to the same post, in Dutch, as there is no translation for that post!
While tinkering with XBMC and MySQL, I had to convert a long list of tables from MyISAM to InnoDB.
The following query nicely creates all ALTER statements needed to modify all your tables:
(replace 'xbmc_video75' with the database name you're working with)
SELECT
CONCAT('ALTER TABLE ', table_name, ' ENGINE=InnoDB;') as UpdateStatements
FROM information_schema.tables
WHERE TABLE_SCHEMA = 'xbmc_video75' AND TABLE_TYPE = 'BASE TABLE'
ORDER BY table_name DESC;
