How long should a 75mb sql file take to import in

问题:

I'm importing a 75mb sql file into MySql using PHPMyAdmin. Specifically, it's the Moby Thesaurus (http://icon.shef.ac.uk/Moby/mthes.html).

75MB doesn't seem that much to me, but it's taking literally days to import. Does this sound right?

回答1:

Do it on command line:

mysql -u USER -p DBNAME < SQLFILE.SQL

Enter password when prompted and there you go.

回答2:

PHPMyAdmin is not the best solution for large imports like that, it loads each row as a separate statement and its import function is best used on smaller data sets such as incremental updates to a table. I'd recommend something more like an ETL software, such as Talend to import your data.

https://www.talend.com/products/talend-open-studio