Hi Joe,
Do you see any errors in your MySQL server log?
You might need to increase the maximum size of an allowed packet, try adding
this to your my.cnf in the mysqld section:
set-variable = max_allowed_packet=32M
Also, it's possible your Innodb tablespace is too small for the file you're
trying to import, for example in your my.cnf file you might have to set the
size of the innodb data file to be something larger like:
innodb_data_file_path = ibdata1:7800M
Beware of doing this though if you already have information stored in inno
db table, you'll have to export the data, change the size of the tablespace
and then reimport the data.
Travis
On 5/2/05, Joe Flowers <jflowers45(a)hotmail.com> wrote:
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!
_______________________________________________
Wikitech-l mailing list
Wikitech-l(a)wikimedia.org
http://mail.wikipedia.org/mailman/listinfo/wikitech-l