From: <dav...@ya...> - 2003-12-19 10:47:27
|
--- Tom Wright <mdb...@ma...> wrote: [...] > > Unfortunatly my data base has carrige returns in > memo fields which cause > mdb-export to seg fault every time. If anyone has a > fix for this can they > please let me know. I submitted a patch for mdb-export.c to: http://sourceforge.net/tracker/?atid=302294&group_id=2294&func=browse [I think I might have got the URL wrong in a previous post] that allows you to specify the row delimiter for exactly this reason. I was then able to export using '|' to mark the end of the row and then tell MySQL to import the data with LINES TERMINATED BY '|'. It was part of some changes I made to do something like mysqldump. I have not tested this on any other backend. Dave ===== David Whiting Adult Morbidity and Mortality Project (AMMP) Box 65243, Dar es Salaam, Tanzania Tel: +255 22 215 33 88 Fax: +255 22 215 33 85 ________________________________________________________________________ Yahoo! Messenger - Communicate instantly..."Ping" your friends today! Download Messenger Now http://uk.messenger.yahoo.com/download/index.html |