I've developed a little script over the years that dumps production databases, and loads them locally on demand, and its been very handy.
However, it was taking ages to load a database on a Virtualbox ubuntu environment I use for debugging with Zend.
A quick look into it, and I found that i'd put
on the mysqldump command sometime in the past.
I changed that to
and the loading has gone from over 12 hours (I was asleep, not waiting for it ;-) down to 30 minutes.