At 10:53 -0500 3/23/02, MySQL wrote: >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?
If you have Perl DBI installed, go to: http://www.kitebird.com/mysql-cookbook/ Then get the "early release" software. It has a mysql_to_filemaker.pl script that does that you want. Or at least I think it does. :-) CR will be converted to control-K, which is what FileMaker uses to represent line breaks internal to a field. It also converts DATETIME and TIMESTAMP columns to separate date and time columns, because FileMaker doesn't have any combined date-and-time type. If you try it and find it lacking, I'd appreciate any criticism. > >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
