Wrong backup?

Wrong backup?

Postby Maicel » Thu 23 Dec 2004 11:16

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
Maicel
 

Re: Wrong backup?

Postby Oleg » Thu 23 Dec 2004 14:51

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.
Oleg
Devart Team
 
Posts: 264
Joined: Thu 28 Oct 2004 13:56

Postby Guest » Fri 24 Dec 2004 11:39

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.
Guest
 

Postby Oleg » Fri 24 Dec 2004 14:20

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.
Oleg
Devart Team
 
Posts: 264
Joined: Thu 28 Oct 2004 13:56


Return to dotConnect for MySQL