Convert MySQL all tables in all databases to InnoDB

H

hkusulja

Registered
Feb 3, 2010
4
0
51
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
 
You must log in or register to reply here.
Thread starter Similar threads Forum Replies Date
Entelekta .frm .ibd convert to SQL cpanel import MYSQL Databases 2
H Convert database Roundcube MySQL to SQLite fail Databases 7
C SOLVED convert from MysqlDB to MariaDB Databases 10
M how to convert direct admin mysql to cpanel sql? Databases 3
B any one converted mysql to mariadb or percona on production server? Databases 2
Similar threads
.frm .ibd convert to SQL cpanel import MYSQL
Convert database Roundcube MySQL to SQLite fail
SOLVED convert from MysqlDB to MariaDB
how to convert direct admin mysql to cpanel sql?
any one converted mysql to mariadb or percona on production server?
Top Bottom