Re: Which Restore goes faster: mysqldump vs. Load Data INFILE

[Bing Wu]

Tony - the "copying data files directly" is a very insightful idea. It so happens that I am using MyISAM tables so this idea should worth a try at least.

While waiting for replies to my original question, I did a test with a smaller test set (10G). After created two dump files--one from "select into" and the other "mysqldump", I restored them on to the same host, same DB and same table (truncated after each restore), to my surprise, restore from the mysqldump file was the faster option. It took only half the time to finish.

Anyway, just want to share the result. It may not be the most authoritative since the disk i/o could be well primed, etc. But the time difference is very significant.

Bing