备份版本问题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
上一篇下一篇

猜你喜欢

热点阅读