Greetings, This is my first post to this list, hope you can help me.
I'm trying to automate nighly exports from MySQL to a Filemaker Pro database. I figured out that the following syntax will get me a tab delimited export file: mysqldump -u root --tab=/directory MyDataBase This is great except for 2 things: 1) It puts "\N" in every field that contains no data. I just want the field to be blank. 2) If a user inputs carriage returns into the database, such as in a Text notes field, the resulting dump file contains actual ASCII 13 CRs inline, so it completely gobs on the tabular structure, which is expecting CRs to be record delimiters. How can I get mysqldump to export some other character instead of carriage returns (preferably ASCII 11) when dumping text fields? Thanks Paul Fabris IT Manager Market Connections Inc. 416-223-2250 x224 www.markcon.com --------------------------------------------------------------------- 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
