Announcement

Collapse
No announcement yet.

Perhaps it would be better to upgrade a test database first

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • SudaBest
    replied
    Hi everybody
    thanks for great topic

    Leave a comment:


  • index
    replied
    Hi All,


    Thanks, I think its better to do a test first then do the upgrade

    Thanks a lot

    Leave a comment:


  • RedWingFan
    replied
    If you have the luxury of enough space to create a second database as a backup, you can skip a step and actually do it all on one line, piping mysqldump right into mysql:

    mysqldump --opt -h(host) -u(db_username) -p(db_password) (current_database_name) | mysql -h(host) -u(db_username) -p(db_password) (new_database_name)

    Replace the parentheses with the appropriate info. Should look similar to this:

    mysqldump --opt -h127.0.0.1 -uroot -paBcDeF123 vbulletin_db | mysql -h127.0.0.2 -ucharlie -p987ZzYy vbulletin_backup

    We just used this to move a vB forum from one server in Texas to another in Pittsburgh and it worked fine! Basically you're doing a dump right into the new database. For a 600MB database it only took us about 25 minutes. (A much larger database, though, we ended up copying the raw database files.)

    One other way to backup your database may or may not be possible depending on the permissions on your server. Forget it if you're on a shared server, but if you're on a dedicated server and have access to the MySQL "data" directory, you can actually copy the raw database files. On my server, they're under /usr/local/var/database_name. What I've done is create a new database using my host's control panel, which gives me a new empty directory in /usr/local/var . Then I can simply copy the files over. It's a lot faster than dumping and importing. (That's how we moved a 1.3GB database, since importing from a dumped file had slowed to a crawl.)

    In all cases, though, I recommend shutting the forum before backing up. You don't want to backup a database that is in the middle of "transactions".

    Leave a comment:


  • Hal9000
    replied
    I have a very large phpbb forum and I want to make a test database before I make the upgrade to vbulletin. Are there any detailed instructions or should I follow pretty much the directions given by eva2000 in the second post ?

    Leave a comment:


  • Baldy
    replied
    Interesting to see how much time it takes on different servers/forums. I've been on step 12, attachment table, for 10 hours now. Mozilla just shows an hourglass cursor.

    Our attachment table is 2.3 gigs, almost all photographs averaging around 70k per. We have 500,000 posts in the forums. The server is dual 700-mhz processor, 2 GB ram, 7200-rpm disks, not much else running on it.

    Leave a comment:


  • Steve Machol
    replied
    See if this helps:

    http://www.vbulletin.com/forum/showp...09&postcount=7

    Leave a comment:


  • Hussain
    replied
    Hi Steve,

    I have read the above link a million times. The problem is that I have never ever backed up my database before leave alone use telenet/SSH before.

    Following the steps please give me your consent accordingly.

    Step One - Backup current database:
    Telnet/SSH into your system (we'll call it machine1)
    Done: Downloaded putty.exe onto the hard drive. My URL is http://www.forums.australian-universities.bz - when typed in the same under host name or IP address, it says network error. Is there something that I am overlooking - or is there an easier way of doing this?

    I think the rest of the steps should be fine. Would really apreciate your help here please. Thanks.

    Leave a comment:


  • Steve Machol
    replied
    See Step 1 here for instructions on making a backup of the db:

    http://www.vbulletin.com/manual/movingservers.html

    Leave a comment:


  • Hussain
    replied
    Would somebody please help me with the upgrade. I just need to know how to take a backup of my database - that is all.

    Thanks.

    Leave a comment:


  • Jirinex
    replied
    Forget the above question.. it was a timeout in the database at the backup procedure.

    Leave a comment:


  • Jirinex
    replied
    Error..

    I am doing the test a local server and i get this error when i try to import the vb2 database to the new database:

    Code:
    C:\Network\MySQL\bin>mysql -u user -p forum < C:\Network\vbulletin.sql
    Enter password:
    ERROR 1064 at line 359728: You have an error in your SQL syntax.  Check the manu
    al that corresponds to your MySQL server version for the right syntax to use nea
    r '<br />
    <b>Fatal error</b>:  Maximum execution time of 30 second

    Leave a comment:


  • wacnstac
    replied
    Additional question about this process

    I have gone through a dry run, upgraded a copy of my old database, gotten the styles/colors the way that I want them, and am pretty much ready to go live with vb3. My question is where are all the style setting stored? I'd like to just torch the upgraded database, make a new copy of my existing live database, and then just re-run the upgrade script and hopefully retain my style settings....

    Leave a comment:


  • Martin
    replied
    Just bumping this so it's active again.....

    Leave a comment:


  • Steve Machol
    replied
    Yes you can do this as long as one of them is strictly a test forum (in 'testvb') and is not accessible to the public. Make sure you set the cookie paths correctly otherwise you will have cookie problems going from one forum to another.

    Leave a comment:


  • crinoid
    replied
    If you are on your own dedicated server, doing a test run is very easy. Simply create an account at a different IP address, create a new blank database and import your current database to that new account using a backup database copy. Then load VB3 and have fun doing tests and tweeks without touching your "live" forums.
    can i run vbulletin v3beta in a different set of folders on the webserver (eg ./forums3/), using a different-named database copy - and simultaneously keep my existing 2.3.0 installation running as usual until i have had time to check that all the mods and hacks i have on my existing board (quite a few) are duplicated in the new version??

    ie run two parallel vbulletins? (the beta one not publicised to my users yet)

    Leave a comment:

widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X