iling List
Subject: RE: Problem with moving database using mysqldump
Hi,
Some of the old mysqldump apps have a bug where they're missing quotes on
long rows. Try the dump the other way - i.e. use the mysqldump client on
the new machine and pipe it from the old machine back to the new machine
(ma
Hi Mike,
I hope you are on linux machine, What are versions on
old and new machines, is there any difference?.
just tar the data dir /var/lib/mysql (in most of the
cases) and untar on the new machines by moving the
existing mysql directory by this old data.
I don't think this will fail, I have
d one...).
With something like:
> mysqldump -h oldmachine -u username olddatabase | mysql newdatabasename
Cheers,
Andrew
Sql,query
-Original Message-
From: Mike Hillyer [mailto:[EMAIL PROTECTED]]
Sent: Friday, 04 October 2002 01:25
To: MySQL Mailing List
Subject: Problem with moving
Hello All;
I am having a problem using the mysqldump application. I have an old server
that I am trying to move to a faster machine. No matter what I do, about 90
queries in the connection ceases and the old meachine gets a server has gone
away error. I have tries runnig mysql dump piped to the m