Phpmyadmin Export/Import issue with line breaks Phpmyadmin Export/Import issue with line breaks wordpress wordpress

Phpmyadmin Export/Import issue with line breaks


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


As Issac said, it seems to be a bug with phpmyAdmin version 4.6.5.1 who generates this problem.In my case, I have searched thru all the .sql file for this 3 strings:

\\r\\n\\n\\r

And replaced them with a space. Everything works perfectly again.