I am trying to use
mysql.exe --username=xxx -password=xxx myDatabaseName < LoadFile.sql
to restore the wikipedia database from the .sql files that they provide.
However, I am running into issues restoring the data. I've been able to
restore from a file as large as 70mb but anything bigger than that seems to
fail. It doesn't give any notification of failure but if it runs overnight it
appears to just stop, and I have to manually close the command prompt window.
This is on a windows server 2003 box.
Does anybody know of any tools that can help handle larger .sql files? I am
planning on trying to load the cur database, which is a 2.5gb .sql file, and
I'd rather not have to split it into 50 different files.
Thanks!