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
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
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
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-
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
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
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