How do I restore my forums?

Discussion in 'Databases' started by WXM Matty, Jan 11, 2009.

0
  1. #1
    I lost all my forums, I mean it all got wiped so I have made a fresh install of Vbulletin.


    I did a massive back up with cPanel wich left me with a folder named 'backup-6.19.2008_18-20-30_pecli.tar'

    I can see my database inside this its name.sql

    Can I some how use this to get all my topics, posts, members and forum layout back?
     
    WXM Matty, Jan 11, 2009 IP
  2. MarkInter

    MarkInter Guest

    Messages:
    50
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Use WinRar to unzip that and then use the restore database process in vBulletin (you can find tutorial about it online).
     
    MarkInter, Jan 11, 2009 IP
  3. WXM Matty

    WXM Matty Peon

    Messages:
    30
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    In the ACP I only see backup NOT restore
     
    WXM Matty, Jan 11, 2009 IP
  4. ExusHost

    ExusHost Banned

    Messages:
    12
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Import the .sql via phpmyadmin then edit /inc/config.php
     
    ExusHost, Jan 11, 2009 IP
  5. ~kev~

    ~kev~ Well-Known Member

    Messages:
    2,866
    Likes Received:
    194
    Best Answers:
    0
    Trophy Points:
    110
    #5
    First thing, how big is the database? Phpmyadmin will only import a database up to a certain size. After a certain amount of time the upload will time out.

    If your talking a database that is over a hundred megs, you can use a program called mysqldumper - mysqldumper.de/en

    Use an ftp program to upload the database to the file manage folder of mysqldumper and then use mysqldumper restore the database.

    If your database is around a gig or more, you may have to use command line from a shell prompt to restore the database. You will need to upload the database to a folder on the server first.

    Do a search of the vbulletin.com site, I remember seeing exact instructions on how to restore the database from a shell prompt.
     
    ~kev~, Jan 12, 2009 IP
  6. MarkInter

    MarkInter Guest

    Messages:
    50
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #6
    I thought you do a google search on "how to restore vBulletin database." You have some good tutorials there!
     
    MarkInter, Jan 12, 2009 IP
  7. Devilfish

    Devilfish Active Member

    Messages:
    396
    Likes Received:
    6
    Best Answers:
    1
    Trophy Points:
    70
    #7
    Devilfish, Jan 12, 2009 IP