Best Way To Bake Up Your Database(s)?

Discussion in 'Databases' started by ProFDesigns, Jul 14, 2007.

0
  1. #1
    Hello,
    What is the safest and best way to download your database for a vbulletin forum and is easy to put back up,
    Would be great to know so i can back the site up everyday
    I am knew with this back up stuff etc.
    I am using the hosting company called: www.dot5hosting.com
    They are pretty cheap and give some nice space and bandwith but horrible support

    Thanks very much!
     
    ProFDesigns, Jul 14, 2007 IP
  2. sawz

    sawz Prominent Member

    Messages:
    8,225
    Likes Received:
    808
    Best Answers:
    0
    Trophy Points:
    360
    #2
    your website control panel must have an option to backup your databases.
     
    sawz, Jul 14, 2007 IP
  3. ProFDesigns

    ProFDesigns Active Member

    Messages:
    124
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    51
    #3
    ^^ yes it does, but i mean, after that, how do I put it back up?
     
    ProFDesigns, Jul 14, 2007 IP
  4. mikeloring

    mikeloring Guest

    Messages:
    21
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    i do not advise getting your database baked unless you plan on feeding it INSERTS -=)
     
    mikeloring, Jul 25, 2007 IP
  5. gibex

    gibex Active Member

    Messages:
    1,060
    Likes Received:
    21
    Best Answers:
    0
    Trophy Points:
    95
    #5
    vbulletin - admin panel
    cpanel - phpmyadmin or
    mysqldump - in ssh

    pick one :)
     
    gibex, Jul 25, 2007 IP
  6. ProFDesigns

    ProFDesigns Active Member

    Messages:
    124
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    51
    #6
    k cool
    thanks :)
     
    ProFDesigns, Jul 26, 2007 IP
  7. gemini181

    gemini181 Well-Known Member

    Messages:
    2,883
    Likes Received:
    134
    Best Answers:
    0
    Trophy Points:
    155
    #7
    Extra effort can pay off:

    Sometimes it's good to have a copy of both
    • Data and structure
    • With data only

    In an emergency, use a fresh installation >> Empty data tables >>> Import (data only) from your backup...
    ...I've had this work better than other ways I know to rebuild a DB.
     
    gemini181, Jul 26, 2007 IP