How to convert data from myisam to innodb?

Question

MySQL

There are 2 databases on different servers. One database uses myisam, the other uses innodb. When transferring any record from one database to another, all Cyrillic characters turn into the "?" character. How can I organize the correct transfer of Cyrillic data using php.

Answer 1

And where does the table engine to the encoding? You have jambs with encodings there.

Answer 2

You somehow crookedly overtake, while the encoding is spoiled, try this:

<?php
$host = 'localhost';
$log = 'login';
$pass = 'PASSWORD';
$db = 'DBNAME';

mysql_connect($host,$log,$pass);
mysql_select_db($db);
$q = mysql_query("SHOW TABLES");
while ($table = mysql_fetch_array($q))
{
        mysql_query("ALTER TABLE `".$table['Tables_in_'.$db]."` ENGINE = InnoDB");
}
?>