1

Convert MySQL all tables in all databases to InnoDB

view story
linux-howto

http://forums.cpanel.net – Hi, I have cPanel server with MySQL 5.5.27, with lot of users and databases. I want to convert all tables in all databases from MyISAM type to InnoDB storage engine, how can I achive this using mysql client from shell with root privileges ? Also, I have added to my /etc/my.cnf for future tables: default-storage-engine=InnoDB Thank you, Kind regards (HowTos)