Announcement

Collapse
No announcement yet.

Can we discuss Backups for Newbies?

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

  • LCD_Angel
    replied
    Thank you Zachery.

    I greatly apprecaite your help. The next step is to update to VB 3!!

    Thanks a million.

    Leave a comment:


  • Zachery
    replied
    If you ran that though SSH then the backup should be complete. OPT does a few things to the database, it does optmize them abit thus making them abit smaller

    Leave a comment:


  • LCD_Angel
    replied
    Yes, I did run the OPT command. I used SSH to generate the file.

    Maybe I should just try again....

    If I get a file with the same / almost same size (within a meg) would it be safe to say that the file is okay?

    Leave a comment:


  • Zachery
    replied
    Did you run the --opt command from the ssh line?

    If your backing up with phpmyadmin your not going to be able to complete it with a database that size.

    Leave a comment:


  • LCD_Angel
    replied
    See Above post as well..

    I am just finding it odd that the backup is like 560 Mb.. while in php my admin if you total the sizes of the tables in the database it says they equal 645 or so Mb.

    Leave a comment:


  • LCD_Angel
    replied
    Great. Alright. Since you are very helpful... is there anyway to know if the backup file is complete? Like is there a line at the bottom that would tell me that the entire database is there and not corrupt?

    Leave a comment:


  • Zachery
    replied
    Yes, the only thing you would need to do is get a fresh copy of the files from vB.com if you lost them, after that the worst thing is you might need to upgrade to the newest vrsion

    Leave a comment:


  • LCD_Angel
    replied
    Okay. But say that my entire server up and died for some reason and nothing was recoverable. Would that have enough info to get the board back up and running on the "original" VB style and setup then?

    Sorry. I'm not real familiar with VB Code and how it works. Just concerned with whether I would have enough data to rebuild a board if it crashed.

    Mark

    Leave a comment:


  • Zachery
    replied
    This contains all data that is in the DATABASE, it doesnt include any files that are on the server.

    The database holds, posts, threads, users, attachments (by default). styles anhd such

    Leave a comment:


  • LCD_Angel
    replied
    So all the backup files are in that one file then? Right....
    Originally posted by Zachery
    ASCII format, its juts one really big text file

    Leave a comment:


  • Zachery
    replied
    ASCII format, its juts one really big text file

    Leave a comment:


  • LCD_Angel
    replied
    That worked thanks Steve.

    Just two easy questions:

    1. Does the dump file contain all the files I need to restore VBulletin on a server if it crashes / gets damaged? (Excluding the files you download when you first buy VB)

    2. Do I download that from my server in .ascii or binary format to save it on my computer?

    Leave a comment:


  • Steve Machol
    replied
    FYI, the instructions for moving servers are in the online manual here:

    http://www.vbulletin.com/docs/html/moving_servers

    Leave a comment:


  • LCD_Angel
    replied
    Okay, so I want to try backup my database using PhP My Admin... but under export there are a lot of options which should I select / not select?

    The options:
    Structure?
    ..Add "drop table"?
    ..Add AUTO_INCREMENT Table?
    Data?
    ..Complete Inserts?
    ..Extented Inserts?
    Save as file? (Okay and where would that file go? My computer or the server?)

    Thank you for any help guys!

    Leave a comment:


  • LCD_Angel
    replied
    The moving servers link looks broken. Can you tell me where to fnd that info?

    Leave a comment:

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