PDA

View Full Version : Time-frame to import 900Mb database from 3.5.4 to 3.6.2



McJ
Tue 7th Nov '06, 5:03pm
Hi folks.

Ballpark. How long would you say it should take to import a 900Mb, 1.3million post vBulletin database into MySQL on a 1Ghz server with 1GB RAM?

Has anyone imported a similar size database?

Thanks in advance.

J.

Interdit
Tue 7th Nov '06, 5:26pm
There will be two steps:

1) importing from a remote ftp (e.g. your old server)
I would say 1000 seconds.
2) restoring the db via ssh
I would say 10 minutes to 20

* to upgrade i don't know, a few minutes ?

McJ
Tue 7th Nov '06, 7:17pm
Thank you Interdit. Would you say it's quicker to import an SQL dump, than export an SQL dump?

Interdit
Wed 8th Nov '06, 10:56am
Quicker to export.