https://cp.beget.com/support/1278547
Файл convert.php
<?php // convert.php
$user = $argv[1];
$database = $argv[2];
$password = $argv[3];
$conn = mysql_connect('localhost',$user,$password);
mysql_select_db($database,$conn);$sql = "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = '{$database}'
AND ENGINE = 'InnoDB'";$rs = mysql_query($sql);
while($row = mysql_fetch_array($rs))
{
$table = $row["TABLE_NAME"];
$sql = "ALTER TABLE `{$table}` ENGINE = MyISAM";
$res = mysql_query($sql);
if(!$res)
{
echo "Table {$table} in {$database} has not been converted\n";
}
else
{
// echo "Table {$table} in {$database} converted\n";
}
}
Eurobyte: MySQL 10.2.40-1.el7.centos
- Сервер: MySQL (Localhost via UNIX socket)
- Тип сервера: MariaDB
- Версия сервера: 10.2.40-MariaDB-log - MariaDB Server
- Версия протокола: 10
- Кодировка сервера: UTF-8 Unicode (utf8)
Beget: MySQL 5.7.21-20-beget-5.7.21-20-1-log (LTD BeGet)