Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Phpmyadmin Export/Import issue with line breaks

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

like image 832
Daniel Avatar asked Dec 12 '25 05:12

Daniel


1 Answers

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

like image 90
Isaac Bennetch Avatar answered Dec 13 '25 22:12

Isaac Bennetch