mysqldump.exe 问题

最新推荐文章于 2024-04-11 11:00:00 发布

转载最新推荐文章于 2024-04-11 11:00:00 发布 · 2.4k 阅读

数据库专栏收录该内容

2 篇文章

订阅专栏

本文介绍了mysqldump版本与MySQL服务器版本不一致导致的备份问题，包括错误提示和相应的解决步骤。通过将MySQL安装目录下的mysqldump.exe复制到MySQLWorkbenchCE安装目录并覆盖原有文件，可以解决该问题。

 
   
        WARNING
       
 
        mysqldump.exe 
        is 
        version 5.5.16, but the MySQL Server 
        to 
        be dumped has version 5.6.11.
       
 
        Because the version 
        of 
        mysqldump 
        is 
        older than the server, 
        some 
        features may 
        not 
        be backed up properly.
       
 
        It 
        is 
        recommended you upgrade your 
        local 
        MySQL client programs, including mysqldump 
        to 
        a version equal 
        to 
        or 
        newer than that 
        of 
        the target server.
       
 
        The path 
        to 
        the dump tool must 
        then 
        be 
        set 
        in 
        Preferences -> Administrator -> Path 
        to
        mysqldump Tool:
       
 
        12:35:48 Dumping shapefiles (countries)
       
 
        Running: mysqldump.exe 
        --defaults-extra-file="c:\users\shixz\appdata\local\temp\5\tmppn0cgl.cnf"  --user=root --max_allowed_packet=1G --host=localhost --port=3307 --default-character-set=utf8 "shapefiles" "countries"
       
 
        mysqldump: Couldn
        't execute '
        SET 
        OPTION 
        SQL_QUOTE_SHOW_CREATE=1
        ': You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
        OPTION 
        SQL_QUOTE_SHOW_CREATE=1
        ' at line 1 (1064)
       
 
        Operation failed with exitcode 2
       
 
        12:35:48 Dumping shapefiles (cities)
       
 
        Running: mysqldump.exe --defaults-extra-file="c:\users\shixz\appdata\local\temp\5\tmpgjfy9u.cnf"  --user=root --max_allowed_packet=1G --host=localhost --port=3307 --default-character-set=utf8 "shapefiles" "cities"
       
 
        mysqldump: Couldn'
        t 
        execute 
        'SET OPTION SQL_QUOTE_SHOW_CREATE=1'
        : You have an error 
        in 
        your SQL syntax; 
        check 
        the manual that corresponds 
        to 
        your MySQL server version 
        for 
        the 
        right
        syntax 
        to 
        use near 
        'OPTION SQL_QUOTE_SHOW_CREATE=1' 
        at 
        line 1 (1064)
       
 
        Operation failed 
        with 
        exitcode 2
       
 
        12:35:48 Dumping shapefiles (rivers)
       
 
        Running: mysqldump.exe 
        --defaults-extra-file="c:\users\shixz\appdata\local\temp\5\tmpiehbkp.cnf"  --user=root --max_allowed_packet=1G --host=localhost --port=3307 --default-character-set=utf8 "shapefiles" "rivers"
       
 
        mysqldump: Couldn
        't execute '
        SET 
        OPTION 
        SQL_QUOTE_SHOW_CREATE=1
        ': You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
        OPTION 
        SQL_QUOTE_SHOW_CREATE=1' 
        at 
        line 1 (1064)
       
 
        Operation failed 
        with 
        exitcode 2
       
 
        12:35:48 Export 
        of 
        C:\Users\shixz\Documents\dumps\Dump20130530 has finished 
        with 
        3 errors
       
 
 