mysql-backup4j icon indicating copy to clipboard operation
mysql-backup4j copied to clipboard

Backslashes in text fields are lost after backup and restore

Open sierracc opened this issue 2 years ago • 3 comments

Backslashes in String fields are lost after backup and restore.

Original text field content: "data\with\backslash";

mysql-backup4j produces an insert statement like this: INSERT INTO [...] VALUES ('data\with\backslash')

After restore, the field contains the value "datawithbackslash". This is because MySQL requires backslashes in SQL to be escaped.

sierracc avatar Jun 02 '22 17:06 sierracc