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
(make sure the new
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
(make sure the new machine has permissions to grab from the old
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
