phpmyadmin导入/导出问题
我有两台服务器，都运行 phpmyadmin，我使用 phpmyadmin 上的导出选项卡在一台服务器上导出了 mysql 转储，并尝试在第二个站点上使用 phpmyadmin 导入查询。
我收到此错误： #1064 - 你的 SQL 语法有错误；检查对应的手册 您的 MySQL 服务器版本，以便在 ' 附近使用正确的语法 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"' at line 1
我查看了文本文件，里面绝对没有“”。我删除了顶部的所有评论，只是为了确保这不是某种奇怪的解释错误。
如果有人有任何想法让 phpmyadmin 真正导入它，我洗耳恭听。不幸的是，这是一个廉价的共享服务器，我没有很多可用的工具。我有 FTP 访问权限和 phpmyadmin 访问权限，但除此之外就没有其他权限了。我通常通过 SSH 执行此操作，不幸的是，他们不信任我具有这种访问权限。
I have two servers, both running phpmyadmin, and I exported a mysql dump on one using the export tab on phpmyadmin, and I tried importing the query with phpmyadmin on the second site.
I get this error:
#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 '
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"' at line 1
I've looked through the text file and there is absolutely no "" in there. I've deleted all the comments at the top just to make sure it isn't some weird kind of interpretation error.
If anyone has any ideas to make phpmyadmin actually import this, I'm all ears. Unfortunately, this is a cheap shared server, and I don't have a whole lot of tools at my disposal. I have FTP access, and phpmyadmin access, but not much else. I usually do this via SSH, unfortunately, they don't trust me with that kind of access.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
表示 BOM。我不知道它是如何到达那里的 -mysqldump不应该这样做。也许该文件已在添加该文件的编辑器中打开并保存。删除 BOM 的方法有多种，请参见 这里。或者，重新转储数据。
The
is indicative of a BOM. I don't know how it got there -mysqldumpshouldn't do this. Maybe the file was opened and saved in an editor that added it.There are various ways of removing a BOM, see e.g. here. Alternatively, re-dump the data.