How to Backup before Upgrading to 4.0

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • TheLastSuperman
    Senior Member
    • Sep 2008
    • 1799

    How to Backup before Upgrading to 4.0

    vBulletin 4.0 - Backups, Upgrades, and Recovery! Updated 1.15.2010
    _____________________________________

    This is an exact duplicate of http://www.vbulletin.com/forum/showthread.php?335689-[Suite-OR-Forum]-How-2-Guide-Backups-Upgrades-and-Recovery!

    Please post any questions about this tutorial in that thread, this way we know it refers to vBulletin Gold and not the Beta as you see in this thread from post #2 to #159. I wanted to leave all these for reference, goodness knows how many times I have hunted down a solution via posts on vBulletin.com and .org via Google .

    _____________________________________

    This is a revised Tutorial from the original info found here: http://www.vbulletin.com/forum/conte...grading-to-4-0 which as you can see by my comment below the Community Tutorial, it has been updated! This information can also be found on vbulletin.org as an Article found here: http://www.vbulletin.org/forum/showthread.php?t=227933

    By:


    Upgrading is an important process and should not be taken lightly. Please be aware you should always do a backup and here is the best way to be perfectly safe about it:

    Section 1 - Don't be stubborn, read the instructions you Grinch .

    1. Check the Minimum Requirements found here:
    The system requirements for vBulletin 4 are higher than vBulletin 3 and are as follows: Minimum: PHP: 5.2.0 MySQL: 4.1.0 Recommended PHP: 5.2.6 - 5.3.x (5.4 only supported with vBulletin 4.2.2)

    Also found here:
    http://www.vbulletin.com/faq.php#faq-125
    If your Hosting account/Server is not up to par with the minimum requirements it might not upgrade at all or cause you more trouble then it's worth! Some host will move you to another server with the minimum requirements if available or perhaps for an additional fee or monthly cost.

    1a. Trevor Hannant has released a very detailed Guide to Upgrading including screenshots so I highly recommend you view all of Trevor's upgrading instructions, they might be just what you need for a super simple upgrade then you can skip the upgrade information below and simply use this forum tutorial if you need to recover your forum or learn some useful information on backups!

    Please see all five parts via the vBulletin CMS however here are the links:








    1b. Another bit of helpful information is Wayne Lukes information on upgrading to 4.0 located here:


    2. Test the backup to see if it will restore in a test environment.
    3. If it restores then use it to test the upgrade but remember to disable all mods in admincp product manager and via Section 4 below in the config file.
    4. If the upgrade was successful... now what? You decide! Change your forums folder name and rename the test one to be your forum, redo cookies to prevent login problems using tools.php and any posts since the time of the backup used are lost... or tell your members now about upgrading and close the board and repeat? Make that choice now and simply read for your parts below it's quite simple to keep up with otherwise post a comment and await a reply.
    5. Well this is step number five so did it work? If so great copy this article and save on your computer with your vbulletin files so you don't have to track it down later if needed - always be prepared!

    Now if you need more details on how to backup, test or restore here is some more information for you.

    PLEASE NOTE YOU SHOULD NOT BE ATTEMPTING TO UPGRADE A LIVE SITE TO vBulletin 4.0!


    Section 2 - Patience is a virtue.

    1. If your upgrading a live site please take the proper precautions such as testing in advance as listed above in Section 1.
    2. You are allowed to run a vbtest under your license I suggest you install or upgrade a backup of your live site first to make sure it goes smoothly IF you are going to in fact upgrade, disregarding our warnings of upgrading a live site. More information on that is here: http://www.vbulletin.com/forum/showt...-READ-ME-FIRST
    3. IF YOUR FORUM IS HEAVILY MODIFIED/CUSTOMIZED EITHER IN TERMS OF CUSTOM MODIFICATIONS AND OR STYLES AND YOUR DISREGARDING THE RECOMMENDATION NOT TO UPGRADE A LIVE SITE - I DO NOT RECOMMEND YOU UPGRADE AT THIS TIME, THAT IS STRICTLY IMO BUT I FEEL INEXPERIENCED OWNERS SHOULD NOT ATTEMPT UPGRADING A LIVE SITE THAT HAS BEEN HEAVILY CUSTOMIZED.


    Section 3 - Better Safe than Sorry.

    1. Backup your Database and Files so you can restore to your current version on your live board now i.e. 3.5/3.6/3.7/3.8 etc if anything goes wrong or to use for making a test site.

    How to do this Mike?

    Database Backup - Cpanel? phpMyAdmin? Do you have any of these? If so let's review some options in each:

    Cpanel:

    There is an option to copy a database using Cpanel but I have not been successful on with it and found simply exporting using cPanel the using BigDump to import into a new databse saved me time trying to figure out other ways with each host being slightly different.To backup follow these steps:

    1. Close your forum.
    2. Use Cpanel to access your phpMyAdmin.
    3. In phpMyAdmin, select the database you want to copy from the menu on the left.
    4. Click export, then click choose "save as file" and save it you your computer along with your vbulletin files.

    MySQLDumper:

    Can be found here: http://www.mysqldumper.net/ & Special Thanks to FF|Skyrider for the reminder!! http://www.vbulletin.com/forum/showt...=1#post1840565)
    1. Follow the information on installing it, run a backup and test a restore. Simple enough and secure using htaccess although I still find BigDump (listed below) to be easier.

    BigDump:

    Some host though have timeouts or limited sessions in place as mentioned above so you attempting to restore it will never work unless you use something like BIGDUMP. Here is some more info on automated backups (do this when you have time) which has links for BIGDUMP so you can upload a large Database.

    1. See the info below, I like to give credit and that's where I found the reference on google.

    XOOPS CMS is an extensible, OO (Object Oriented), easy to use dynamic web content management system (CMS) written in PHP. XOOPS is the ideal tool for developing small to large dynamic community websites, intra company portals, corporate portals, weblogs and much more.


    From that page, credit to XOOPS see post for details on author:

    Restore

    Bigdump, The script

    Thanks Alexey Ozerov (alexey at ozerov.de) for this script that imports big SQL dump files on limited sessions servers. Script Valid with IE 6.0 SP1, mozilla 1.x and Netscape 4.8.

    Description:

    Staggered import of large MySQL Dumps (like phpMyAdmin 2.x dumps and even GZip compressed dumps). Do you want to restore a large backup of your mySQL database (or a part of it) into a new or the same mySQL database? Maybe you can't access the server shell and you can't import the dump using phpMyAdmin due to hard memory/runtime limit of the web-server. BigDump will achieve this
    even with webservers with hard runtime limit and those in safe mode in a couple of short sessions.

    Download:
    Hot Scripts is the net's largest PHP, CGI, Perl, JavaScript and ASP script collection and resource web portal. We are an Internet directory that compiles and distributes Web programming-related resources, geared toward webmasters, developers and programmers looking for enhancing their Web sites and intranets with dynamic development tools.


    Installation and configuration

    One unique script. Modify setup vars ( DB connection and gzip file URL) and upload it on your server.

    Use

    This is a manual operation (Databases are not usually restored daily)
    Post gziped sql Dump at devoted URL and run the script.

    Comment
    Simple, ths script is an excellent DB_Backup complement. No more sql files cut to fit phpMyAdmin sessions that a so boring (and dagerous) as your DBs bocomes too big.
    When using phpMyAdmin here are the setting I normally check (within the yellow highlighted area in the image) that I normally check before exporting, otherwise some systems default options checked will not work properly if re-importing



    1a.Check out this information as well posted by Floris!

    Originally posted by Jhumon
    Hello users and team

    how do i restore my databases after upgrading to 4.0 ?

    can anyone help me in this ?
    Originally posted by Floris


    Section 4 - Practice Makes Perfect.

    Now that you have made a test site (or if upgrading now on a live site) you need to do a few things first to make sure it all goes smoothly. You have backed up and either already rushed off and upgraded or you have restored a copy of your database and your ready to create a test environment for mods or to test an upgrade on! Let's see how to restore the files below:

    1. If your making a backup of your site to test for mods or an upgrade copy the folder your forum is in and rename it then upload back to your server via FTP (i.e. Filezilla) or the Cpanel File Manager or Legacy File Manager (Retain a copy of the original files and do not alter them). Filezilla I find to be quicker than Cpanel file managers but long story short you want to make a backup all the files, every single folder and file. Why? Well if you have problems while upgrading to 4.0 you have already uploaded the new files so they will not work if you try to restore if the upgrade fails OR if making a test site you need ca copy of the original files to properly restore the site exactly as it is. Some FTP Clients do not automatically upload files in the correct mode, please read the install information provided by vBulletin to upload the correct files in the correct mode i.e. ASCII or Binary etc.

    2. Download your current version (3.6 or 3.7/3.8 etc etc) and I mean the exact same version your forum is running now before the upgrade this will be needed to restore if required. Also retain an unaltered copy fo your entire forum folder on your computer as listed above in step 2.

    3. Turn off ALL MODIFICATIONS. You can do this by disabling them all but the best and highly recommended way of doing this is by locating your config.php file and edit it (make a copy of it first and do not use notepad to edit use an external editor such as notepad ++ google it etc) and at the top below <php? add this:

    Code:
    define('DISABLE_HOOKS', true);
    *YOU MUST DISABLE MODS BEFORE UPGRADING, not afterwards when it failed the first time, NOW.

    3a. Revert back to your Default style, this is important and can be the difference between a viewable forum after your upgrade. If you do not have a default style or have modified it in some way please remember you can simply create a new fresh default style via the Style Manager.

    ** DELETE ALL OLD vBulletin 3.x Styles this can cause problems when upgrading if you do not! Only revert to default OR make a new Default for your 3.x before you upgrade!!

    3b. While your in the config file of whatever site your upgrading be sure to change the database details to match the new database!!!

    3c. In your browser navigate to your forums url i.e. http://www.yoursite.com/forum/install/upgrade.php provide your customer number and then follow the prompts on screen and upgrade!

    Did it work? If yes then great! Enjoy

    Quick Tips
    * Don't forget to turn back on the mods so your CMS and Blog will work, you can now uninstall unwanted 3.x mods one at a time until they are removed if you did not uninstall them before upgrading and remember to delete the files associated with the modifications as well.

    ** If your experiencing some problems with links not working properly or something seems funky try:
    (Thanks Birute for the Reminder!)
    a) Clear your cookies, CLOSE your browser and then launch your browser again i.e. Internet Explorer, Firefox, Safari, Opera etc etc.
    b) If that does not remedy it try: AdminCP > Maintenance > Update Counters and start updating! READ them all carefully as some can reset statistics you wish to retain and they will not be recoverable once the counters are updated unless you fall back to the most recent backup and possibly redo the upgrade process so be very careful and if anything refer to the older vBulletin 3 Manual as much of it stil pertains to the 4.0 version it just needs a bit of updating but for reference it's perfect: http://www.vbulletin.com/docs/html/



    ===================================


    If the backup worked and your forum is upgraded and running fine please stop reading this guide now and go have fun with vBulletin 4.0! If you have any Bugs please confirm they are not specific to only you for some reason i.e. MySQL or PHP versions (Although you should have confirmed the minimum requirements were met before upgrading regardless).

    ===================================


    Section 5 - What a bloody mess...

    Continuing with this Guide from here down means you had a failed upgrade and wish to restore!

    Big forum or you just don't want your live site to stay down while you wait on a fix.. is there a fix? Frantic are you? Well simply restore back to your previous version if you saved a copy of your forum files and database as you were told to above!

    Depending on where the install script failed, it might not have modified you current database so you see errors because it's new files for 4.0 not communicating properly w/ the 3.x database . Simply re-upload your previous versions files as if you were updating and then run the upgrade script, there is an option to run it anyways please click that and proceed.

    If it did not alter the DB then you should see your live site back up! If it still shows errors then you might be in trouble and want to restore back to your previous version or if you did not make a backup now might be the time to submit a support ticket otherwise without a backup you will need to do a fresh install and have all your members re-register.


    Section 6 - The mop bucket.

    1. You can try restoring your database via phpMyAdmin but some host have file upload or session limits/timeouts in place. You can ask them to restore it for you which is the quickest way.

    They won't restore or charge $$$.$$ ?

    Now you must do the rest plain and simple, buck up and let's get this done Good Sir! (or Lady )

    1a. Restore it yourself by using Cpanel, MySQLDumper, or BigDump as listed above in Section 3 - Better Safe than Sorry and remember when restoring to change the config file details to the new database and you might have to run the tools.php as listed above in Section 1 - Don't be stubborn, read the instructions a copy of it is located in your do_not_upload folder that came with your vBulletin forum or suite download. Again, in regards to restoring your Database, if your not having success and it's getting to you that bad simply contact your host and ask for their assistance.

    1b. Your files... Upload all of them back to the same directory and all the files are as they were with the database now restored!

    Now check and see if it's restored? I hope it goes well for many of you, I had to save a 3.8 forum a while back from an owner who jumped then gun and tried to install herself http://www.vbulletin.com/forum/showt...of-upgrade-php so I thought I would post this up since many will be here for 4.0 ?'s and support just like many will only be on vbulletin.com!
    ______________________________
    Last edited by TheLastSuperman; Fri 15 Jan '10, 8:17am.


    Former vBulletin Support Staff
    Hacked recently? See my blog post "Recovering a Hacked vBulletin Site".
    Thinking outside the box? Need modification support? Visit www.vBulletin.org and have at it!
  • Brittany
    New Member
    • Jul 2008
    • 22
    • 3.7.x

    #2
    thank you mike!

    Comment

    • TheLastSuperman
      Senior Member
      • Sep 2008
      • 1799

      #3
      Originally posted by Brittany
      thank you mike!
      No problem! (It was Brittany's forum btw everyone )

      I fixed it by simply reuploading the files and telling the upgrade script to go ahead anyways

      Brittany said in a PM.. "I know I'm being impatient" ... I replied back saying "No your not being impatient your just worried " so any of you with errors take a breather and check for solutions here by the members .

      Mike


      Former vBulletin Support Staff
      Hacked recently? See my blog post "Recovering a Hacked vBulletin Site".
      Thinking outside the box? Need modification support? Visit www.vBulletin.org and have at it!

      Comment

      • TheLastSuperman
        Senior Member
        • Sep 2008
        • 1799

        #4
        Better instructions

        REMOVED: Please see my updated post #1 Above.
        Last edited by TheLastSuperman; Sat 14 Nov '09, 8:24am.


        Former vBulletin Support Staff
        Hacked recently? See my blog post "Recovering a Hacked vBulletin Site".
        Thinking outside the box? Need modification support? Visit www.vBulletin.org and have at it!

        Comment

        • Skyrider
          Senior Member
          • Feb 2006
          • 540

          #5
          Neat guide Superman. I think it would be also nifty to add the following backup/restore software: http://www.mysqldumper.net/

          I use this site software for very large databases, and is quite handy. Can back-up large files in to files for you to download and restore from the site as well in to databases that you select. Can also select which tables you wish to be restores rather than doing the whole deal.

          Comment

          • TheLastSuperman
            Senior Member
            • Sep 2008
            • 1799

            #6
            Originally posted by FF|Skyrider
            Neat guide Superman. I think it would be also nifty to add the following backup/restore software: http://www.mysqldumper.net/

            I use this site software for very large databases, and is quite handy. Can back-up large files in to files for you to download and restore from the site as well in to databases that you select. Can also select which tables you wish to be restores rather than doing the whole deal.
            Added above & Thanks for the reminder Skyrider! I use that myself on two sites

            Mike


            Former vBulletin Support Staff
            Hacked recently? See my blog post "Recovering a Hacked vBulletin Site".
            Thinking outside the box? Need modification support? Visit www.vBulletin.org and have at it!

            Comment

            • Lynne
              Former vBulletin Support
              • Oct 2004
              • 26255

              #7
              A bump to get people to notice this. I can't believe how many people are not reading the php/mysql requirements, not doing a backup and not disabling their plugins first.

              THIS IS IMPORTANT!!!!!!

              Thank you for taking the time to write this out, Michael!

              Please don't PM or VM me for support - I only help out in the threads.
              vBulletin Manual & vBulletin 4.0 Code Documentation (API)
              Want help modifying your vbulletin forum? Head on over to vbulletin.org
              If I post CSS and you don't know where it goes, throw it into the additional.css template.

              W3Schools &lt;- awesome site for html/css help

              Comment

              • TheLastSuperman
                Senior Member
                • Sep 2008
                • 1799

                #8
                Originally posted by Lynne
                A bump to get people to notice this. I can't believe how many people are not reading the php/mysql requirements, not doing a backup and not disabling their plugins first.

                THIS IS IMPORTANT!!!!!!

                Thank you for taking the time to write this out, Michael!
                Well Brittany from last night appreciated the help and I said well let's make sure others don't fall prey to simply not knowing

                Keep posting if you like the above that way it stays up top for all to read until someone stickies it *cough *cough

                Mike
                Last edited by TheLastSuperman; Sat 14 Nov '09, 10:15am.


                Former vBulletin Support Staff
                Hacked recently? See my blog post "Recovering a Hacked vBulletin Site".
                Thinking outside the box? Need modification support? Visit www.vBulletin.org and have at it!

                Comment

                • Steve Machol
                  Former Customer Support Manager
                  • Jul 2000
                  • 154488

                  #9
                  Very good. Stickied this for now.
                  Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                  Change CKEditor Colors to Match Style (for 4.1.4 and above)

                  Steve Machol Photography


                  Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                  Comment

                  • TheLastSuperman
                    Senior Member
                    • Sep 2008
                    • 1799

                    #10
                    Originally posted by Steve Machol
                    Very good. Stickied this for now.
                    Thanks for the cough drops Steve (see above, post #8 everyone.. just me being silly lol)

                    Edit: I know I just made a funny above lol HOWEVER since this is stickied, please only post questions you have regarding the above Backup & Restore to Pre 4.0 if upgrade fails and I will try to answer any questions you have on the posted info. I have a few prior engagements today but I'll be on throughout the day and weekend to check up on everyone. Thanks in advance for keeping this thread clean so we can help each other with real issues if trying to revert back from a 4.0 failed upgrade .
                    Last edited by TheLastSuperman; Sat 14 Nov '09, 10:28am.


                    Former vBulletin Support Staff
                    Hacked recently? See my blog post "Recovering a Hacked vBulletin Site".
                    Thinking outside the box? Need modification support? Visit www.vBulletin.org and have at it!

                    Comment

                    • Mark.B
                      vBulletin Support
                      • Feb 2004
                      • 24286
                      • 6.0.X

                      #11
                      Originally posted by Lynne
                      A bump to get people to notice this. I can't believe how many people are not reading the php/mysql requirements, not doing a backup and not disabling their plugins first.

                      THIS IS IMPORTANT!!!!!!

                      Thank you for taking the time to write this out, Michael!
                      I didn't read them but it doesn't matter a jot. It mostly still installed. I just don't get the CMS yet. It'll be sorted soon.

                      To be honest I'd still have gone ahead even if I *had* read them, just to see what happened! It's only a test mirror so I don't care....
                      MARK.B
                      vBulletin Support
                      ------------
                      My Unofficial vBulletin 6.0.0 Demo: https://www.talknewsuk.com
                      My Unofficial vBulletin Cloud Demo: https://www.adminammo.com

                      Comment

                      • TheLastSuperman
                        Senior Member
                        • Sep 2008
                        • 1799

                        #12
                        Originally posted by Mark.B
                        I didn't read them but it doesn't matter a jot. It mostly still installed. I just don't get the CMS yet. It'll be sorted soon.

                        To be honest I'd still have gone ahead even if I *had* read them, just to see what happened! It's only a test mirror so I don't care....
                        Well just remember that some are actually attempting to update their LIVE site but if your using a copy of a site to test your good Mark as you said but again some are actually attempting to upgrade this Beta release on their LIVE site which is not recommended.

                        Mike


                        Former vBulletin Support Staff
                        Hacked recently? See my blog post "Recovering a Hacked vBulletin Site".
                        Thinking outside the box? Need modification support? Visit www.vBulletin.org and have at it!

                        Comment

                        • Sworm1
                          Senior Member
                          • Feb 2008
                          • 488
                          • 4.0.0

                          #13
                          I have php 5.2.11 and Mysql 5.0.81-community, can i upgrade?

                          Comment

                          • FaiSao
                            Member
                            • Nov 2009
                            • 48
                            • 3.8.x

                            #14
                            Thank you ..

                            We wait Gold
                            Version
                            Foreign Man ..!

                            Comment

                            • avitor
                              Senior Member
                              • Jun 2007
                              • 354

                              #15
                              where to upload the file i buckup? from my phpadmin ?
                              how to use the buckup ?
                              thanks
                              http://www.horadot.co.za

                              Comment

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