MySQL restore is very slow

It seems there is a bug in MySQL which is causing restores to run very slowly (hours instead of minutes)

The bug is fixed in release 5.0.67

But Ubuntu hasn't updated yet....

Fortunately this bug is specific to the command line client.

Workaround: use the MySQL Administrator GUI instead.

Written on 4th of August 2008

Comments

Submitted by sean on Tue, 08/05/2008 - 13:47.

unfortunately the GUI is still slow ...

I'm working on applying the patch to the ubuntu/debian package
another alternative is to grab the source for mysql 5.1 and compile just the client

This client can then be used for restoring backups
Either define the socket location at compile time or use the runtime option

./mysql --socket=/var/run/mysqld/mysqld.sock

Otherwise you'll get an error like:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Got something to add - just enter a comment
all other fields are optional.