Page 1 of 1

Wrong backup?

Posted: Thu 23 Dec 2004 11:16
by 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

Re: Wrong backup?

Posted: Thu 23 Dec 2004 14:51
by 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.

Posted: Fri 24 Dec 2004 11:39
by 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.

Posted: Fri 24 Dec 2004 14:20
by 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.