The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Convert MySQL all tables in all databases to InnoDB

Discussion in 'Database Discussions' started by hkusulja, Dec 2, 2012.

  1. hkusulja

    hkusulja Registered

    Joined:
    Feb 3, 2010
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    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
     
Loading...

Share This Page