导入数据库备份返回＃1064 [英] Import database backup return #1064

问题描述

突然导入数据库备份返回下面的错误。
奇怪的是，导入旧的工作副本是有效的。
如果我以后导出，我尝试重新导入它，该文件会给出此错误。

Suddenly importing database backup returns the error below. The odd thing is that importing an old working copy it works. If I export it straight afterwards and I try to re-import it the file gives this error.

看起来是导致问题的PhpMyAdmin导出。
PhpMyAdmin导出过程中是否有任何改变，我不知道？

Looks like it's PhpMyAdmin export that causes issue. Is there any change in PhpMyAdmin export process that I'm not aware of?

这个看起来像我的问题，但解决方案对我来说无效。

This looks like my problem but the solution didn't work for me.

There is a chance that you may have found a bug in the SQL parser. 
Please examine your query closely, and check that the quotes are 
correct and not mis-matched. Other possible failure causes may be 
that you are uploading a file with binary outside of a quoted text 
area. You can also try your query on the MySQL command line interface. 
The MySQL server error output below, if there is any, may also 
help you in diagnosing the problem. If you still have problems or 
if the parser fails where the command line interface succeeds, please 
reduce your SQL query input to the single query that causes problems, 
and submit a bug report with the data chunk in the CUT section below:

----INIZIO CUT----
eNo1jU0KwjAYRIXuvlPMAWIw0SrNLoTQLvJn0roXF1IQ3Sjo7U0FZ/UYHjM255gVjICRcDYoCEgI
QWWsdUPkP+XoFFou+L5b3x5XmkpGLAy6t2FkONkq+vMFZsjR22puuOwoea2wq9xSGtJisViWnS0X
B7j5/nqT06FXmJ/0u6Bm9c8XSs4hPQ==
----FINE CUT----

----INIZIO RAW----
ERROR: C1 C2 LEN: 1 2 11
STR: MySQL: 5.1.69-log
USR OS, AGENT, VER: Mac CHROME 5.0.29
PMA: 4.0.5
PHP VER,OS: 5.3.17 Linux
LANG: it
SQL: 

----FINE RAW----



Query SQL:

Messaggio di MySQL: 
#1064 - 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 '' at line 1

(I translated what I could in the error as my phpmyadmin is in Italian)

推荐答案

你正在运行一个过时的phpMyAdmin版本。我相信在 https://sourceforge.net/p/phpmyadmin/bugs/4095中提到的修复/ （即将到来的4.0.8版本）将帮助您。

You are running an outdated phpMyAdmin version. I believe that the fix mentionned in https://sourceforge.net/p/phpmyadmin/bugs/4095/ (for the upcoming 4.0.8 version) will help you.

直接链接到修复程序（可应用于4.0.7）： https://github.com/phpmyadmin/phpmyadmin/commit/b717657de77db0b58179bdbdd88e23d0fc3d7ea6

Direct link to the fix (can be applied to 4.0.7): https://github.com/phpmyadmin/phpmyadmin/commit/b717657de77db0b58179bdbdd88e23d0fc3d7ea6

这篇关于导入数据库备份返回＃1064的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！