A
A
Andrey Belov2017-04-19 18:41:26
MySQL
Andrey Belov, 2017-04-19 18:41:26

How to dump MysqlSQL without escaping tag quotes?

Greetings.
When uploading a dump via PHPMyAdmin, Sypex, Adminer, SSH console (mysqldump), etc., we get an export with quotes escaped:

<span class=\"clear\">текст</span>
<div class=\"blockq\">текст</div>

Previously, I somehow exported without it, but due to lack of sleep, I have been frantically stupid for a week now and I can’t even google something like I did.
Thank you.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
A
anton_lazarev, 2017-04-19
@Sonicelf

mysqldump db_name | sed -e 's/\\"/"/g'

N
Ne-Lexa, 2017-04-19
@NeLexa

Escaping is used to write a valid SQL file.
Import the data and the database and there will be no quotes.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question