Le Chateau De Virieu-Sur-Bourbre, Isere (1877) - Johan Barthold Jongkind

Import Big MySQL Databases Faster

I recently had to import some quite large SQL dumps to my local machine for data analysis purposes. There were 10 different .sql dumps in total, and each of them were sized more than 100GB. Naive Attempt First of all, I tried to import each by using the < operator: mysql some_database < some_dump.sql Unsurprisingly, each task took very long to finish, approximately 6-7 hours per dump file, in a brand new laptop with i7 CPU, 16GB RAM and 1TB SSD....

April 5, 2017 · 2 min · Serhat M. Dündar