Backslashes in text fields are lost after backup and restore

[sierracc]

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.

[Josel099]

@SeunMatt When exporting data using this library, I'm encountering the same issue with the handling of backslashes in strings. This is what I'm getting when I try to export data using this library.

INSERT INTO `backup`(`id`, `saas_client_id`, `created_at`, `created_by`, `last_modified_by`, `modified_at`, `deleted_at`, `deleted_by`, `is_deleted`, `name`, `destination_path`, `filename`, `fs_backup_status`, `db_backup_status`) VALUES 
('4', '1', '2024-07-17 05:06:20.846334', '1', null, null, null, null, 0, 'db Backup test_1', 'C:\Users\Josel\Desktop\backup_test', '20240717-103620.zip', 0, 2);

But the strings with slashes are not being escaped properly. Please note the value of destination_path column "C:\Users\Josel\Desktop\backup_test". When I try to import it back to DB it doesn't get inserted as the original value. For example it's corrupted like this: "C:UsersJoselDesktopackup_test" While exporting I want to get slashes escaped like the following: "C:\\Users\\Josel\\Desktop\\backup_test". when I manually export the dump file, the strings with slashes are escaped correctly .

[osteffl]

To export all types of characters properly in String type, I needed to do more escaping work - here is my code:

private String getDataInsertStatement(String table) throws SQLException { ... // escape the single quotes that might be in the value val = val .replace("\", "\\") // Escape backslashes first .replace("'", "\'") // Escape single quotes .replace(""", "\"") // Escape double quotes, if necessary .replace("\n", "\n") // Escape newlines .replace("\r", "\r") // Escape carriage returns .replace("\t", "\t"); // Escape tabs

[Josel099]

@osteffl Thanks for sharing this! Your escaping approach is super helpful.