Restoring a Database

Discussion in 'Forum Management' started by BlueEew, Jan 28, 2008.

  1. #1
    Hey, I have a forum that is ran off a free forum providing service. However I would like to move to my own server soon. I have actually already installed the phpBB 3 software etc. I would like to know how I would restore the database after I have downloaded the backup from the free supplier.

    You see it costs some money to be able to get a backup, so I kind of want to get this done the first time around. The forums are running phpBB 2, and the hosted forum I want to move to is phpBB 3 the latest download. I need to know the following as soon as possible please.

    Will I be able to use the phpBB 2 database, and move to the new phpBB 3?

    Will all members, posts, forums, everything be moved over?

    Also how would I restore the database? Install phpBB 3 like I have, the use a backup to overwrite the new database? How dose it work?

    Also here is the Topic from the free forums support forums. They have some problems stated, I was just wondering if these will be a problem from me etc.

    Thanks,
    BlueEew.
     
    BlueEew, Jan 28, 2008 IP
  2. mdvaldosta

    mdvaldosta Peon

    Messages:
    4,079
    Likes Received:
    362
    Best Answers:
    0
    Trophy Points:
    0
    #2
    You shouldn't have any problems doing that. You'd need to edit your phpBB2 database to contain the proper domain name and path (look in the config table) and then import it via phpmyadmin or something of the sort. Once it's imported you should be able to use phpBB3's update ability to upgrade from phpBB2 to 3.
     
    mdvaldosta, Jan 28, 2008 IP
  3. ravi_9793

    ravi_9793 Banned

    Messages:
    576
    Likes Received:
    35
    Best Answers:
    0
    Trophy Points:
    0
    #3
    1) From old host...download full home backup + Database backup + Email Backup.
    2) Log in new cpanel, and restore all backups.....
    3) create a databse user as same as old one, and give full power (if user is not created through restore)
    4) change nameserver of the domain name.
    As soon as nameserver is updated, your forum will be on your server.

    But within time of updating nameserver, you will loose posts, threads and others.

    5) Once you have moved to your own host...now upgrade to phpbb3.
     
    ravi_9793, Jan 28, 2008 IP
  4. SurgerY

    SurgerY Guest

    Messages:
    25
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Ravi, more or less, gave you a detailed explanation of the process to follow...
    If you still encounter any problems, just bump this thread with the part where you're getting stuck while restoring your database, and we'll be more than glad to help:)
     
    SurgerY, Jan 29, 2008 IP
  5. BlueEew

    BlueEew Well-Known Member

    Messages:
    2,434
    Likes Received:
    79
    Best Answers:
    1
    Trophy Points:
    150
    #5
    So I would have to install phpBB 2, move it to that. Then upgrade to phpBB 3?
     
    BlueEew, Jan 29, 2008 IP
  6. mdvaldosta

    mdvaldosta Peon

    Messages:
    4,079
    Likes Received:
    362
    Best Answers:
    0
    Trophy Points:
    0
    #6
    You could if you wanted to, just be more work. No reason you can't just point the phpBB3 upgrader to the phpBB2 database and let it rip though. Like I said, just make sure the phpbb_config table has the correct domain and script path settings.
     
    mdvaldosta, Jan 29, 2008 IP
  7. BlueEew

    BlueEew Well-Known Member

    Messages:
    2,434
    Likes Received:
    79
    Best Answers:
    1
    Trophy Points:
    150
    #7
    So this should work even though the current phpBB 2 forum isn't hosted on my server, I will have only a backup? If so thats all good. :) Have you checked the topic I poited out with know problems?

    Will there be any problems there? Also is there a guide somewhere what I can read, so I know what I have to edit in config?
     
    BlueEew, Jan 30, 2008 IP