Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Incomplete
-
5.5.42, 10.1.8
-
Windows server 2012
Description
We are moving a database from MySQL version 5.1.40sp1-enterprise-gpl-pro-log , to MariaDB 10.1.8, by using Mysqldump and the command 'mysql --password=xxx -u mybackup ik_db < e:\sqldump\ik_db_bu.sql' to move to the new database.
The old Mysql server use Encoding UTF-8 (65001), Database character set :latin 1--cp1252 Western European, Collation: latin1_swedish_ci.
The new Mariadb server use Encoding UTF-8 (65001),Database:character set : utf8 – UTF-8 Unicode, Collation: utf8_general_ci.
Most tables is transferred ok, however one table (Innodb) give the error: ERROR 2006 (HY000) at line 481: MySQL server has gone away.
The field where it stops is of type longblob.
By importing the sql dump to a new database on the old Mysql server, it runs ok without error messages.