导出/导入Phpmyadmin换行符 [英] Phpmyadmin Export/Import issue with line breaks

问题描述

我尝试通过phpmyadmin从我的旧主机导出wordpress数据库。

我将所有设置保留在默认的sql文件中，所有的新行由\\\
命令分隔（或\\\
或\\\
\\\
）

然后我通过phpmyadmin将这个sql文件导入到我的新服务器，但现在在phpmyadmin中，换行符不可见，但你可以看到很多\\\
和\\\
\\\

在旧的phpmyadmin中，我看不到那些\ n，而是有真正的换行符。

当通过浏览器查看页面时，它更糟。 Theres不仅仅是\\\
而且还有\\\\

有什么想法，可能是什么问题？ （都是utf8）

编辑：

我确定它更多导出然后是导入问题，因为我从另一个主机提前导入的另一个数据库工作正常，那些\的工作，但我不知道为什么这个1备份被破坏

解决方案

您在每个系统上使用哪个phpMyAdmin版本？出现导致此问题的版本4.6.5.1的错误。 phpMyAdmin 4.6.5.2已经发布以解决此问题，或者您可以使用此修补程序，如果您愿意的话。 / p>

编辑以包括已发布4.6.5.2的消息

I try to export a wordpress database from my old host via phpmyadmin.
I leave all settings on default and in the sql file, all new lines are seperated by "\n" command (or "\n" or "\n\n")

Then i import this sql file into my new server via phpmyadmin, but now in phpmyadmin the line breaks are not invisible, but u can see alot of "\n" and "\n\n"

In the old phpmyadmin i couldnt see those "\n", instead there were real line breaks.
And when looking at the page via browser, its even worse. Theres not only "\n" but also "\r\n"

Any ideas please, what could be the problem?! (both are utf8)

edit:

i am sure it is more an export then an import problem, because another database i imported earlier from another host, worked fine and those "\n"'s work, but i have no idea why this 1 backup is broken

解决方案

Which phpMyAdmin version are you using on each system? There is a bug with version 4.6.5.1 that causes this issue on export. phpMyAdmin 4.6.5.2 has been released to address this, or you can use this patch if you desire.

Edited to include the news that 4.6.5.2 has been released

这篇关于导出/导入Phpmyadmin换行符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！