Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-9115

The Mysql server is gone when impoting a sql file

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Incomplete
    • 5.5.42, 10.1.8
    • N/A
    • Server
    • 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

          People

            elenst Elena Stepanova
            SOG Steinar Gravem
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.