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?
Do it on command line:
mysql -u USER -p DBNAME < SQLFILE.SQL
Enter password when prompted and there you go.
1.4m articles
1.4m replys
5 comments
57.0k users