If you use mysqldump, escape the fields with proper escaping characters. You will get a proper dump.
Rgds Insane SQLyog - The Definative GUI for MySQL http://www.webyog.com/sqlyog ----- Original Message ----- From: "Jean-Francois nadeau" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 15, 2002 11:44 PM Subject: How to : Export BLOB > Hi all, > > I use a mix of innodb and MyIsam tables under 3.23.52. > > As mysqldump does not supports BLOB, how do you export / import databases > for backup puposes. I dont want to stop the engine to backup or use a tool > that exports all databases (like Innodb hot backup). I want to backup a > selected database which contains BLOB in Innodb and MyIsam tables. Any > perl script available ? > > Thanks for your help > > Jeff > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php