Big database upgrade to vB3

[robin_ge]

vB3 is going to be released later next week. I'm planning to upgrade my forum to vB3. I have a big database around 120MB. I can't use HafaBee's script (http://forum.powweb.com/showthread.php?threadid=20022) since there is a daemon that kills programs that run too long.

What's your suggestion about backup and restore big database?
Thank you in advance!

[mjp]

The vBulletin upgrade scripts will handle all of the database migration and changes for you. Check the forums over at vBulletin for a discussion about upgrading a large database. They have some tips you can use if you run into timeouts.

[robin_ge]

Originally posted by mjp
The vBulletin upgrade scripts will handle all of the database migration and changes for you. Check the forums over at vBulletin for a discussion about upgrading a large database. They have some tips you can use if you run into timeouts.

Thanks for the reply, my question was actually a more general one on backup and restore big database.

For upgrading vB3, I'm worrying about that if something goes wrong when upgrading, I can restore the database and upgrade again. But the problem is that I can't get a full database backup, so restoring is impossible even when I can use HalfaBee's script to do the restore.

Thank you again for your answer, mjp!

[HalfaBee]

You have to do the restore in bits.
I haven't tried a 120MB restore, but have done a few 20-30MB ones.
The backup file has to be split into 71000 line sections and each one restored in sequence.
120 MB could be roughly 15-20 files, using 3 users it would take 5 hours.
There are ways around this if you want to do it quicker. ;)

[cryogenikz]

yes i would highly recommend halfbee's services, he did mine when i changed over from godaddy.com and the transition was as smooth as butter, so to speak :)

[robin_ge]

Originally posted by HalfaBee
You have to do the restore in bits.
I haven't tried a 120MB restore, but have done a few 20-30MB ones.
The backup file has to be split into 71000 line sections and each one restored in sequence.
120 MB could be roughly 15-20 files, using 3 users it would take 5 hours.
There are ways around this if you want to do it quicker. ;)

I have seen the split command in UNIX, but how do I slpit the 120MB file in Windows(I'm using Windows)?

5 HOURS!!!:eek: That's horrible. What are the ways to get around this, could you tell me? Thanks!! :D

[HalfaBee]

Are you trying to restore it to a Powweb server or your local one?

[robin_ge]

Originally posted by HalfaBee
Are you trying to restore it to a Powweb server or your local one?

Well, currently I'm not going to restore the database. I just want to be prepared if something goes wrong when I upgrade to vB3 next week.

It would be nice to know how to backup and restore in both romote server and the local one. Thank you, HalfaBee!!