Announcement

Collapse
No announcement yet.

Backup using Admin CP

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

  • Backup using Admin CP

    I understand I can backup via Admin CP, I've found the appropriate tools in it and wanted to ask a couple of questions

    1) what is considered a"larger" database ?? i'm assuming the details in adminCP of data usage, index usage etc are the figures involved

    2) do I need to switch forums off as i do this?? , current forum size is only about 45 meg

    TIA

  • #2
    1. There is no easy answert for this. It depends on the server ands whether or not the backup option times out.

    2. Yes you should close your forums when making a backup.

    Note: The only consistently reliable method of backing up and restoring a database is with shell access via telnet or ssh. 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

    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.
    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
      Thanks

      I'll give it a go and see what happens then contact my ISP to discuss shell on Monday.

      Any idea how long it'll take to do a 50 meg backup so I can advise my users how long it'll be off line - ie 5 minutes 60 minutes, a few hours??

      Originally posted by Steve Machol
      1. There is no easy answert for this. It depends on the server ands whether or not the backup option times out.

      2. Yes you should close your forums when making a backup.

      Note: The only consistently reliable method of backing up and restoring a database is with shell access via telnet or ssh. 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

      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.

      Comment


      • #4
        50 Mb should only take a few minutes, depending on the server of course.
        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


        • #5
          And if SSH is too complex, there's MySQLDumper. It's a script that does bite-at-a-time backups and restores of MySQL to get around these limitations.

          Comment

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