Wrong backup?

[Maicel]

Hello!

I make a Backup from my db with the Sample Application mysqlDump.

In my DB ist a Text in a Table like : & q u o t ; Some Text & q u o t ;

This meens in HTML: " Some Text "
& q u o t ; represent an " in HTML .
Whenn i done the Backup the "& q u o t ;" is defect.



Why is this so?

mfg

Maicel

[Oleg]

MySqlDump adds quoting for special symbols so generated SQL can be executable always.
You can read in the documentation for MySQL what symbols must be quotes.
If you call Restore at your example data will be restored correctly.

[Guest]

This is my problem. When I call ab Restore, the special symbols are parsed wrong. I become an other special symbol, that is not correct.

[Oleg]

What MySQLDirect .NET version do you use? We tested with MySQLDirect .NET version 2.70.1. What special symbols are the causes of the problem? We tested values with ". Please send your dump text for your single test table that demonstrates the problem to our support email.