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)

http://bugs.mysql.com/bug.php?id=33057

The bug is fixed in http://dev.mysql.com/doc/refman/5.0/en/releasenotes-cs-5-0-67.html

But Ubuntu hasn’t updated yet….

Fortunately this bug is specific to the command line client.

Workaround: use the MySQL Administrator GUI instead.