Percona Toolkit moved to https://jira.percona.com/projects/PT

  1. Bug #1030975
  2. Comment #2

Comment 2 for bug 1030975

Revision history for this message
Mike Isman (mfp7) wrote : Re: Double quotes results in a syntax error

The destination host is indeed using ANSI_QUOTES:

source db:

mysql> SELECT @@GLOBAL.sql_mode;
+-------------------+
| @@GLOBAL.sql_mode |
 +-------------------+
| |
 +-------------------+
1 row in set (0.00 sec)
destination db:

mysql> SELECT @@GLOBAL.sql_mode;
+---------------------------------------------------------------------------------------------------+
| @@GLOBAL.sql_mode |
 +---------------------------------------------------------------------------------------------------+
| ANSI_QUOTES,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION |
 +---------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)