MGSteve
Well-known member
I've done a test run through of mine,
371,568 threads,
4m posts,
55,000 users
I pruned off all the inactive users with no activity & no posts in the last 12 months, pruned off all the banned accounts over 12 months old and removed all the accounts awaiting activation over 12 months old.
So, we pruned off about 1200 posts & 30,000 user accounts (!!) The forum is 8 years old, so a fair amount of junk in there, to be quite honest.
Here's the import screen, so you can see the times. The server in this case was my desktop W7 machine (Core i7 @ 3.6Ghz, 12GB Ram, Raptor HDD), but as others have said, load is pretty minimal during transfer. It was markedly slower (posts alone took 8 hours) the first time through when the Web server was on one server and the DB was my desktop. It may well be worth doing the migration with the web server & DB on the same box and then move the web files off onto the normal server if you have them separate.

The only thing I can't do is rebuild the search indexes at the moment as there is a bug in b5.
The attachments speed was hampered by the files being on the file server, so there was some LAN overhead there. It should be quicker if they're on the same machine.
371,568 threads,
4m posts,
55,000 users
I pruned off all the inactive users with no activity & no posts in the last 12 months, pruned off all the banned accounts over 12 months old and removed all the accounts awaiting activation over 12 months old.
So, we pruned off about 1200 posts & 30,000 user accounts (!!) The forum is 8 years old, so a fair amount of junk in there, to be quite honest.
Here's the import screen, so you can see the times. The server in this case was my desktop W7 machine (Core i7 @ 3.6Ghz, 12GB Ram, Raptor HDD), but as others have said, load is pretty minimal during transfer. It was markedly slower (posts alone took 8 hours) the first time through when the Web server was on one server and the DB was my desktop. It may well be worth doing the migration with the web server & DB on the same box and then move the web files off onto the normal server if you have them separate.

The only thing I can't do is rebuild the search indexes at the moment as there is a bug in b5.
The attachments speed was hampered by the files being on the file server, so there was some LAN overhead there. It should be quicker if they're on the same machine.