How Long Should A 75mb Sql File Take To Import In Phpmyadmin?

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

Solution 1:

Do it on command line:

mysql -u USER -p DBNAME < SQLFILE.SQL

Enter password when prompted and there you go.

Solution 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