Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
5.5.52
-
None
-
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
- relates to
-
-
- Closed
-