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
