1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

MySQL DB Restorations

Discussion in 'MySQL' started by clookid, Mar 23, 2007.

0
  1. #1
    Hey everyone,

    I am running a general forum at http://www.postmaniac.info and I am changing forum hosts, how would I go about restoring the database? I have already downloaded the back up but I do not know how to restore the database properly... Thanks!

    Kind regards,
    -Clookid
     
    clookid, Mar 23, 2007 IP
  2. Your Content

    Your Content Banned

    Messages:
    1,096
    Likes Received:
    45
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Upload the database to your new server and then upload bigdump after change the values described inside the one-file script.

    This is the easy way to restore your database because if you use phpMyAdmin you may end up with timeout errors

    Bigdump is available here: www.ozerov.de/bigdump.php

    P.S., do not forget to update your phpBB configuration file as well ;)
     
    Your Content, Mar 23, 2007 IP
    clookid likes this.
  3. Richie_Ni

    Richie_Ni Illustrious Member

    Messages:
    10,721
    Likes Received:
    1,175
    Best Answers:
    0
    Trophy Points:
    410
    #3
    Do you have cpanel?
     
    Richie_Ni, Mar 23, 2007 IP
  4. clookid

    clookid Notable Member

    Messages:
    1,042
    Likes Received:
    162
    Best Answers:
    0
    Trophy Points:
    225
    #4
    Thanks Your Content! I will give it a try now, I'll tell you how it goes!

    Richie_Ni, yes I do!
     
    clookid, Mar 23, 2007 IP
  5. Richie_Ni

    Richie_Ni Illustrious Member

    Messages:
    10,721
    Likes Received:
    1,175
    Best Answers:
    0
    Trophy Points:
    410
    #5
    I think it's easy to restore the database if you have cpanel.
    Click "Backups" and they choose the database on you pc,they click upload.Your done.
     
    Richie_Ni, Mar 23, 2007 IP
  6. clookid

    clookid Notable Member

    Messages:
    1,042
    Likes Received:
    162
    Best Answers:
    0
    Trophy Points:
    225
    #6
    Yes, I have tried this... It installs two databases, "localhostsql" and "localhostsqlkey." When trying to connect to either of them on the configuration file, it does not work.

    Also, BigDump: http://postmaniac.info/dump/bigdump.php
     
    clookid, Mar 23, 2007 IP
  7. Richie_Ni

    Richie_Ni Illustrious Member

    Messages:
    10,721
    Likes Received:
    1,175
    Best Answers:
    0
    Trophy Points:
    410
    #7
    Not sure whats your problem,try to connect to the first one.
     
    Richie_Ni, Mar 23, 2007 IP
  8. clookid

    clookid Notable Member

    Messages:
    1,042
    Likes Received:
    162
    Best Answers:
    0
    Trophy Points:
    225
    #8
    I no longer have access to the first database, it would be a whole lot easier if I did!

    EDIT: Yay! I do until the 1st of May!
     
    clookid, Mar 23, 2007 IP
  9. clookid

    clookid Notable Member

    Messages:
    1,042
    Likes Received:
    162
    Best Answers:
    0
    Trophy Points:
    225
    #9
    Nevermind guys! I have worked it out! I realized that I actually had to create a database to do the restoration, I thought that it would automatically create one out of the back up! :D
     
    clookid, Mar 23, 2007 IP