备份版本问题ERROR
2018-12-13 本文已影响112人
三斤耳朵
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.exe Ver 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
Db characterset: utf8
Client characterset: utf8
Conn. characterset: utf8
TCP port: 3306
Uptime: 12 sec
Threads: 1 Questions: 5 Slow queries: 0 Opens: 12 Flush tables: 1 Open tabl
es: 6 Queries per second avg: 0.417
--------------
远程版本
mysql> \s
--------------
mysql Ver 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
Db characterset: latin1
Client characterset: utf8
Conn. characterset: utf8
TCP port: 3306
Uptime: 30 days 18 hours 16 min 55 sec
Threads: 20 Questions: 28057 Slow queries: 0 Opens: 3677 Flush tables: 1 Op
en tables: 956 Queries per second avg: 0.010
--------------
更新本地数据库版本
mysql> \s
--------------
mysql Ver 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
Db characterset: latin1
Client characterset: gbk
Conn. characterset: gbk
TCP port: 3306
Uptime: 35 sec
Threads: 1 Questions: 31 Slow queries: 0 Opens: 33 Flush tables: 1 Open tab
les: 26 Queries per second avg: 0.885
--------------
备份远程数据
C:\Users\Administrator>mysqldump -h 47.93.234.104 -u cxc -pSoft171+172 cxc>C:\U
sers\Administrator\Desktop\cxc20181213.sql