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

Error Restoring mysqldump in MariaDB 5.5

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 5.5.52
    • Fix Version/s: 5.5
    • Component/s: Parser, Scripts & Clients
    • Labels:
      None
    • Environment:
      Linux; Ubuntu 12.04.5 LTS; 64-bit

      Description

      I'm getting an error restoring a mysqldump. At first, I was restoring the full dump (with data), but fortunately, I'm able to elicit the same error, on the same line, with just a structure/routine dump.

      Dump

      $ mysqldump -h myhost -umyuser -p --no-data --routines --single-transaction mysite_cms > /vagrant/temp/downloads/misc/prod_skeleton.sql

      Restoration

      $ mysql -uroot -p mysite_raw_redacted < /vagrant/temp/downloads/misc/prod_skeleton_redacted.sql
      ERROR 1064 (42000) at line 1451: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '*/' at line 1

      SQL

      The third line (with the comments) is the problematic one.

      ...
      DELIMITER ;;
      /*!50003 CREATE*/ /*!50017 DEFINER=`mysite_cms`@`%`*/ /*!50003 TRIGGER cal_tbl_event_delete
      AFTER DELETE ON cal_tbl_event
      FOR EACH ROW
      	INSERT INTO delete_log(deleted_id, deleted_date, deleted_table)
          VALUES (Old.id, now(), 'cal_tbl_event'); */;;
      DELIMITER ;
      ...
      

      Source DB

      +-------------------------+---------------------+
      | Variable_name           | Value               |
      +-------------------------+---------------------+
      | innodb_version          | 5.5.49-MariaDB-38.0 |
      | protocol_version        | 10                  |
      | slave_type_conversions  |                     |
      | version                 | 5.5.52-MariaDB      |
      | version_comment         | MariaDB Server      |
      | version_compile_machine | x86_64              |
      | version_compile_os      | Linux               |
      +-------------------------+---------------------+
      

      Target DB

      +-------------------------+---------------------------------+
      | Variable_name           | Value                           |
      +-------------------------+---------------------------------+
      | innodb_version          | 5.5.52-MariaDB-38.3             |
      | protocol_version        | 10                              |
      | slave_type_conversions  |                                 |
      | version                 | 5.5.53-MariaDB-1~precise        |
      | version_comment         | mariadb.org binary distribution |
      | version_compile_machine | x86_64                          |
      | version_compile_os      | debian-linux-gnu                |
      +-------------------------+---------------------------------+
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              wlad Vladislav Vaintroub
              Reporter:
              Jamie Jackson Jamie Jackson
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated:

                  Git Integration

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