View Single Post

  #1 (permalink)  
Old 03-04-2008
ist
 
Posts: n/a
Default 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...
Reply With Quote