All tables to InnoDB Convert to UTF8

gistfile1.sql

SELECT CONCAT('ALTER TABLE ',table_schema,'.',table_name,' ENGINE=InnoDB;')
FROM information_schema.tables
WHERE 1=1
    AND engine <> 'MyISAM'
    AND table_schema NOT IN ('information_schema', 'mysql', 'performance_schema');

SELECT CONCAT('ALTER TABLE ',table_schema,'.',table_name,' CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;')
FROM information_schema.tables
WHERE 1=1
    AND collate <> 'utf8_general_ci';