Easiest way to load table dump into database

Question

I have a 71GB file having contents of one table of mysql database. Loading that takes me couple of days. Is there a easier way to load the data. I am not sure if removing indexes or splitting files actually helps.

How stackoverflower's solve this problem.

Answer 1

You can use the LOAD DATA command. More info here.

Answer 2

Have you tried removing the indexes? Is the dump using extended inserts?

Instead of removing you can also disable indexes: ALTER TABLE foo DISABLE KEYS; and re-enable with ALTER TABLE foo ENABLE KEYS;

If you can control the data getting dumped another good option is to export to a CSV file. MySQL's LOAD DATA INFILE is faster than loading a SQL dump.

Answer 3

In the shell:

mysql dbname < dbname.sql