备份版本问题ERROR 备份版本问题ERROR

C:\Users\Administrator>mysqldump -h 47.93.234.104 -u cxc -pSoft171+172 cxc>C:\Us ers\Administrator\Desktop\cxc20181213.sql mysqldump: Couldn't execute 'SET OPTION SQL_QUOTE_SHOW_CREATE=1': You have an er ror in your SQL syntax; check the manual that corresponds to your MySQL server v ersion for the right syntax to use near 'OPTION SQL_QUOTE_SHOW_CREATE=1' at line 1 (1064)

实际上是由版本问题引起的
本地版本

mysql> \s -------------- C:\AppServ\MySQL\bin\mysql.exeVer 14.12 Distrib 5.0.51b, for Win32 (ia32)Connection id:1 Current database: Current user:ODBC@localhost SSL:Not in use Using delimiter:; Server version:5.0.51b-community-nt-log MySQL Community Edition (GPL) Protocol version:10 Connection:localhost via TCP/IP Server characterset:utf8 Dbcharacterset:utf8 Client characterset:utf8 Conn.characterset:utf8 TCP port:3306 Uptime:12 secThreads: 1Questions: 5Slow queries: 0Opens: 12Flush tables: 1Open tabl es: 6Queries per second avg: 0.417 --------------

远程版本

mysql> \s -------------- mysqlVer 14.14 Distrib 5.5.27, for Win32 (x86)Connection id:1945 Current database: Current user:cxc@115.239.171.245 SSL:Not in use Using delimiter:; Server version:5.7.24 MySQL Community Server (GPL) Protocol version:10 Connection:47.93.234.104 via TCP/IP Server characterset:latin1 Dbcharacterset:latin1 Client characterset:utf8 Conn.characterset:utf8 TCP port:3306 Uptime:30 days 18 hours 16 min 55 secThreads: 20Questions: 28057Slow queries: 0Opens: 3677Flush tables: 1Op en tables: 956Queries per second avg: 0.010 --------------

更新本地数据库版本

mysql> \s -------------- mysqlVer 14.14 Distrib 5.5.62, for Win32 (AMD64)Connection id:4 Current database: Current user:root@localhost SSL:Not in use Using delimiter:; Server version:5.5.62-log MySQL Community Server (GPL) Protocol version:10 Connection:localhost via TCP/IP Server characterset:latin1 Dbcharacterset:latin1 Client characterset:gbk Conn.characterset:gbk TCP port:3306 Uptime:35 secThreads: 1Questions: 31Slow queries: 0Opens: 33Flush tables: 1Open tab les: 26Queries per second avg: 0.885 --------------

【备份版本问题ERROR】备份远程数据