美文网首页
备份版本问题ERROR

备份版本问题ERROR

作者: 三斤耳朵 | 来源:发表于2018-12-13 16:01 被阅读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
    

    相关文章

      网友评论

          本文标题:备份版本问题ERROR

          本文链接:https://www.haomeiwen.com/subject/cjkbhqtx.html