Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Convert MySQL all tables in all databases to InnoDB

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

  1. hkusulja

    hkusulja Registered

    Feb 3, 2010
    Likes Received:
    Trophy Points:
    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:

    Thank you,
    Kind regards

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice