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.
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| 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=solo -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: {color:red}ERROR 2006 (HY000) at line 481: MySQL server has gone away.{color} 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. |
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: {color:red}ERROR 2006 (HY000) at line 481: MySQL server has gone away.{color} 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. |
| Labels | innodb | innodb need_feedback |
| Fix Version/s | N/A [ 14700 ] | |
| Resolution | Incomplete [ 4 ] | |
| Status | Open [ 1 ] | Closed [ 6 ] |
| Resolution | Incomplete [ 4 ] | |
| Status | Closed [ 6 ] | Stalled [ 10000 ] |
| Labels | innodb need_feedback | innodb |
| Assignee | Elena Stepanova [ elenst ] |
| Fix Version/s | N/A [ 14700 ] |
| Fix Version/s | 5.5-galera [ 21900 ] | |
| Fix Version/s | 10.0-galera [ 21901 ] | |
| Fix Version/s | 10.1 [ 16100 ] |
| Component/s | Server [ 13907 ] | |
| Component/s | Character Sets [ 10801 ] | |
| Fix Version/s | N/A [ 14700 ] | |
| Fix Version/s | 10.1 [ 16100 ] | |
| Fix Version/s | 5.5-galera [ 21900 ] | |
| Fix Version/s | 10.0-galera [ 21901 ] | |
| Resolution | Incomplete [ 4 ] | |
| Status | Stalled [ 10000 ] | Closed [ 6 ] |
| Labels | innodb | innodb need_feedback |
| Workflow | MariaDB v3 [ 72506 ] | MariaDB v4 [ 149815 ] |