Vesta Control Panel - Forum

Posted: **Fri Dec 25, 2015 8:14 am**

Hello

whmcs default db uses mysiam db format. But Vesta using innodb by default. I want to convert my existing innodb database to myisam format and also want my vestacp should use myisam as default db. Please let me know how can I do that.

Posted: **Mon Dec 28, 2015 10:44 am**

I want to convert my existing innodb database to myisam format

M..okey:

Code: Select all

<?php
    // connect your database here first 
    // 

    // Actual code starts here 

    $sql = "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
        WHERE TABLE_SCHEMA = 'your_database_name' 
        AND ENGINE = 'MyISAM'";

    $rs = mysql_query($sql);

    while($row = mysql_fetch_array($rs))
    {
        $tbl = $row[0];
        $sql = "ALTER TABLE `$tbl` ENGINE=INNODB";
        mysql_query($sql);
    }
?>

Posted: **Mon Dec 28, 2015 10:45 am**

rainh wrote:also want my vestacp should use myisam as default db

Hmm... m..okey

https://dev.mysql.com/doc/refman/5.5/en ... tting.html

Vesta Control Panel - Forum

Want to use MyISAM db

Want to use MyISAM db

Re: Want to use MyISAM db

Re: Want to use MyISAM db