Are you exporting/importing with HeidiSQL? If you change the "Max INSERT size" value to... really anything but the default 0, it'll work a -helluvalot- faster.
I like running at 1024 KB, but you can run it at a -tiny- tiny number like 16 KB, and it'll both export and import an order of magnitude faster.
|