mysqldump Unknown command """.

--001485e9a605aeb6be0475e08b65
Content-Type: text/plain; charset=ISO-8859-1

We dumped a mysql 4.1.22 database using the mysqldump binaries from its
version,
We tried to import this in 5.0.82 and we have the error.

mysqldump Unknown command '\''.

It seems the the extended import (multiple inserts) is somewhere too big
since the single insert dump works but takes ages and we need to import this
300gb database in a couple of days.

Any suggestions?
Thanks
--
Claudio

--001485e9a605aeb6be0475e08b65--

Re: mysqldump Unknown command """.

mysqldump is by no means the fastest way to move data between systems.
For a bulk job of this magnitude, try this:

http://dev.mysql.com/doc/refman/5.1/en/load-data.html

- michael dykman


On Wed, Oct 14, 2009 at 3:59 AM, Claudio Nanni wr=
ote:
> We dumped a mysql 4.1.22 database using the mysqldump binaries from its
> version,
> We tried to import this in 5.0.82 and we have the error.
>
> =A0mysqldump Unknown command '\''.
>
> It seems the the extended import (multiple inserts) is somewhere too big
> since the single insert dump works but takes ages and we need to import t=
his
> 300gb database in a couple of days.
>
> Any suggestions?
> Thanks
> --
> Claudio
>



--=20
- michael dykman
- mdykman@gmail.com

Don=92t worry about people stealing your ideas. If they=92re any good,
you=92ll have to ram them down their throats!

Howard Aiken

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg