Mysqldump options
Hi,
(Previosly I have posted this query in Newbie. I have repost here, since we are working on migration b/w sqlite to mysql and for safety copy those to sqlite also)
Is there any option in mysqldump to store the varchars and blob data with in double quotes. since it store those data in single quotes , if a varchar or blob contain a single code then while reading the file from sqlite, the insert fails.
Please update me, is there any option in mysql dump to do that.
Also, try to set --hex-blob only for specific tables (I wish to use this only for BLOB data type). If I use this option all the varchars willl also changed to binary state.
Thanks in advance,
Regards,
Rahul
Subject
Written By
Posted
Mysqldump options
May 29, 2009 09:16AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.