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 <claudio.nanni@stripped> wrote:
> 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
>
--
- michael dykman
- mdykman@stripped
Don’t worry about people stealing your ideas. If they’re any good,
you’ll have to ram them down their throats!
Howard Aiken
