Re: Re-REQUEST: proper way to export with the --tab function???

2005-12-20 Thread Hassan Schroeder
Bruce Carey wrote: > - my problem is that when a text field, with html in it, it makes it > into several hundred recs Well, that's strange -- I use mysqldump to dump/xfer/load records with fields containing HTML regularly, using the mysqldump defaults, and have no problems. Have you tried the de

Re: Re-REQUEST: proper way to export with the --tab function???

2005-12-19 Thread Bruce Carey
Great, that's further than I was before... SO, about the problem of enclosing the fields: - if I am going to have " and \r and \n in fields, what should I enclose them with? - my problem is that when a text field, with html in it, it makes it into several hundred recs - maybe a different line/r

Re: Re-REQUEST: proper way to export with the --tab function???

2005-12-19 Thread Bruce Carey
Great, that's further than I was before... SO, about the problem of enclosing the fields: - if I am going to have " and \r and \n in fields, what should I enclose them with? - my problem is that when a text field, with html in it, it makes it into several hundred recs - maybe a different lin/re

Re: Re-REQUEST: proper way to export with the --tab function???

2005-12-19 Thread Hassan Schroeder
Bruce Carey wrote: > I posted this earlier, could someone take a look at it? In the time since you first posted, you could have at least glanced at the Fine Manual :-) which shows that: >> mysqldump --opt --fields-terminated-by='\t' >> --fields-optionally-enclosed-by='#*#*#' Any of the field-

Re-REQUEST: proper way to export with the --tab function???

2005-12-19 Thread Bruce Carey
I posted this earlier, could someone take a look at it? TIA, Bruce. On Mon, 19 Dec 2005 02:15:54 -0500 "Bruce Carey" <[EMAIL PROTECTED]> wrote: Hi List, I have recently had a crash coursh in the fineer points of db recovery due to a mis-managed server. Could someone help me out with advi

Re: proper way to export with the --tab function

2005-12-18 Thread Jørn Dahl-Stamnes
On Monday 19 December 2005 08:15, Bruce Carey wrote: > Hi List, > > I have recently had a crash coursh in the fineer points of > db recovery due to a mis-managed server. > > Could someone help me out with advice on the proper syntax > for doing mysqldump? I have a rather large db (4.2GB), and > reg

proper way to export with the --tab function

2005-12-18 Thread Bruce Carey
Hi List, I have recently had a crash coursh in the fineer points of db recovery due to a mis-managed server. Could someone help me out with advice on the proper syntax for doing mysqldump? I have a rather large db (4.2GB), and regular dump files get easily corrupted, so I found out, plus LO