Creating Backup SQL manually
Hi,
I wish to create exactly the same SQL that backup module of PHPMyAdmin
creates. I want to achieve it with ASP.NET, I have tried many times
and get the nearest result with MyODBC driver. However, I am having
problems with special characters (because the field contains encoded
data), for example;
-I have noticed that PHPMyAdmin creates SQL codes with \n characters,
ASP.NET converts them to line breaks. I have corrected this by
replacing \n's with \\n in ASP.NET
-Similar situations occur in \ and ' characters, corrected them by
replacing.
-In PhpMyAdmin, there is a box character for an ASCII code, this
occurs in ASP.NET as \b and so ASP.NET renders it as backspace.
The third situation is weird, I haven't found how to handle it in a
generic way. For example, I can manually replace \b's with box
character, however this is only one situation and I may be missing
many other special cases like this.
So, the bottom line: How can I achieve exactly same SQL code with
ASP.NET? Is there a special SQL Query for this (I am not talking about
Backin-up to files), or if I have to do it manually, can I get a
complete reference?
Thanks...
|