Announcement

Collapse
No announcement yet.

Backing up

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

  • Backing up

    Im not exactly sure how it works, so if somebody can explain me that be great and where I back up my forums

    Let's say a mod is pissed and decides to delete all topics and stuff I need to be able to put in the backup and all my topics and stuff will remain
    Last edited by Humbler; Tue 28th Dec '10, 2:40pm.

  • #2
    Note: If someone delete things, there is no practical way to just restore the deleted data. For this reason, you should make regular database backups, daily if possible.

    The only consistently reliable method of backing up and restoring a database is with shell access via telnet or ssh. This is because backing up with a PHP script like that in the Admin CP or phpMyAdmin can result in PHP timeout errors and an incomplete backup file.

    Please see the instructions here:

    Backup:
    http://www.vbulletin.com/docs/html/m...nce_ssh_backup

    Restore:
    http://www.vbulletin.com/docs/html/m...ce_ssh_restore

    If you don't have telnet or SSH access, some people have reported success with these scripts:

    MySQLDumper:
    http://www.mysqldumper.net/

    MySQLHotxcopy:
    http://www.vbulletin.com/forum/showt...t=mysqlhotcopy
    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


    • #3
      Wait, so all topics and content created are being held on the webhost? Then what's the regular database backing up function in VB for?

      Comment


      • #4
        Originally posted by Humbler View Post
        Wait, so all topics and content created are being held on the webhost? Then what's the regular database backing up function in VB for?
        To backup your database. The problem is it "times out" if your backup is over 1gb. Some webhosts limit php execution to 30 seconds. A backup would normally take 5-10 minutes. (Assuming your database is +-1gb)

        I personally use http://www.mysqldumper.net/ for my database (2.5gb) and I find best results with a cron job using the perl backup script included. It normally takes about 9 minutes for my backups. Never times out and it even has the option to optimize you tables before backups Perfect solution for me. Maybe the perfect solution for you too? Has a nice setup GUI no hard editing needed.

        Comment


        • #5
          Yes, the data is held in the database on the server.
          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


          • #6
            Originally posted by need2fart View Post
            To backup your database. The problem is it "times out" if your backup is over 1gb. Some webhosts limit php execution to 30 seconds. A backup would normally take 5-10 minutes. (Assuming your database is +-1gb)

            I personally use http://www.mysqldumper.net/ for my database (2.5gb) and I find best results with a cron job using the perl backup script included. It normally takes about 9 minutes for my backups. Never times out and it even has the option to optimize you tables before backups Perfect solution for me. Maybe the perfect solution for you too? Has a nice setup GUI no hard editing needed.
            How exactly does this work for VB?

            Comment

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