TheTAZZone - Internet Chaos

PHPBB Backup & Restore Tutorial

ORIGINALLY POSTED BY Omen FOR THETAZZONE/TAZFORUM HERE

Do not use, republish, in whole or in part, without the consent of the Author. TheTAZZone policy is that Authors retain the rights to the work they submit and/or post…we do not sell, publish, transmit, or have the right to give permission for such…TheTAZZone merely retains the right to use, retain, and publish submitted work within it’s Network

PHPBB3 – backup & restore tutorial (this tutorial should apply to other forum/bbs on mysql)

For this tutorial we will use several methods to backup and restore mysql databases.

Since you are reading this guide and need to back the database then you may already have a running server or have it hosted somewhere, for those who don’t have a server here is some software to get you hosting.

These downloads are for Windows, but the back up process is more or less universal.

SERVERS
Appserv: http://www.appservnetwork.com/
Wamp server: http://www.wampserver.com/en/download.php
XAMPP: http://www.apachefriends.org/en/xampp-windows.html

MYSQL ADDON
PHPmyAdmin: http://www.phpmyadmin.net/home_page/downloads.php << this eases MYSQL administration by providing a web interface.

Please Read this tutorial from beginning to end first, I am not any good at writing and tend to write in parallel, so some stuff may apply to you some might not.

Considerations:
• Any forum mods for any forum/s, will molest the database and your forum: most mods aren’t updated or thoroughly tested, this means you will have to install exactly the same mods onto your forum for your database to work properly.
• Usually the new (restore) forum version and the mods version/s have to be the same version as the old (backup).
• Large SQL files are messy and a real pain to restore.

There are lots of ways to back up your phpbb, a full backup includes your entire phpbb directory and the full SQL database (or at least the part where phpbb was).

If your host backs up your site, then it should be a full backup. Backing up the database yourself isn’t so difficult, follow the steps.

BACKUP

1. The UI content (suggest a better name for the files, if you have one)
Use your favourite ftp client to download the entire phpbb directory and all its contents, this is needed if you installed any mods or would like to see any uploaded stuff in your restored forum.
Skip this if you Have PHPBB3 with SQL attachments & haven’t installed any mods.

2a. Backup SQL data – via PHPBB
SQL holds everything important, backing it up once in a while will save you hair and your friends (everybody hates re-registering for a failed/deleted SQL forum).
Lets assume you have your forum installed and running, log into the “administrators control panel” then select the “Maintenance” tab and click on “Backup” in the menu.

Select “Full” , “GZIP” , “STORE AND DOWNLOAD” , then click “SELECT ALL” and then click “SUBMIT”

Save the file somewhere.
That’s it you’re done.

NOTE: Ticking “Store and download” makes a backup in the “phpbb/store” (phpbb = where your phpbb is installed) directory so you can restore via the restore option.

2b. Backup SQL data – via phpMyAdmin
Most *nix web hosts will have phpMyAdmin installed, usually it’s only accessible via your host’s control panel. Click on phpmyadmin (in your control panel, could be found under database management) or http://yourdomain.com/phpmyadmin , so your screen looks like this:

Find your phpbb3 database in the “existing databases” list and click on it, then click on the export tab, you should see this:

Lets start clicking, click “SELECT ALL” (NOTE: if you have only one database with more than just phpbb3 then you need to select ONLY the tables beginning with “phpbb_”), then click in the “SQL” select circle, then click “SAVE AS A FILE”, then “ZIPPED” and lastly click the “GO” button to have a download pop-up, now save your phpbb SQL data somewhere.
That’s it you’re done.

RESTORE

3a. Restoring via PHPBB3
You will need to install phpbb3, keeping the phpbb3 administrator settings & table prefix the same as your previous forum !

After you have installed your forum, use your favourite FTP client to upload the “SQL” file to phpbb/store , look at picture to understand the directory structure.

Now, login into your phpbb “ADMINISTRATOR CONTROL PANEL”, go to “MAINTENANCE” tab, then “RESTORE”. If you have done the previous bit correctly you should see this:

If, however you uploaded the “SQL” files to the incorrect directory you will see this:

If you don’t see any backups, retrace your steps and learn the directory structure of phpbb/store.
If you do se a backup or two, select the one you would like to restore and click start restore.
That’s it you’re done !

3a. Restoring via phpMyAdmin
Lets go back to phpmyadmin, either through your hosts control panel or directly http://yourdomain.com/phpmyadmin

Select your pbpbb database from the existing databases and click on it, then click on the “IMPORT” tab, then click the “BROWSE”

Select your saved “SQL” backup file (either zipped, gzipped or plain sql)
and then click the “GO” button.
If you get “Import has been successfully finished, 212 queries executed.” displayed on this same page, then you have restored your pbpbb backup. The number of queries will vary according to the size of your forum.

I would like this tut to be informative and undestandable, comments & corrections welcome.

PDF = http://rapidshare.com/files/134613074/b … phpbb3.pdf

03 August 2008 – PBPBB Backup & Restore Tutorial Release

12 Responses to PHPBB Backup & Restore Tutorial

  1. CicecePem January 7, 2012 at 7:03 pm

    Great post :) Like it…

  2. cpa columbus June 29, 2011 at 2:08 pm

    Nice post!

  3. Pingback: PHPBB Backup & Restore Tutorial « TheTAZZone Blog ( formerly Security News Front )

  4. Croacia April 4, 2010 at 9:34 pm

    Tnx for tutorial!

  5. admin March 17, 2010 at 7:22 pm

    You should join our forum at: http://www.tazforum.thetazzone.com

  6. Amber Lynn March 11, 2010 at 8:22 pm

    Hi !! I’m the fresh new right here but i’m really interested in web development.
    Would really adore to reveal thoughts on php development and improvement myself here.
    Wishing to know about jake?
    Which I have come to know about is virtually a link between Cakephp and Joomla?
    How can these really merge and provide a direct effect to web development in php??

  7. Hydrolyze October 15, 2009 at 10:37 am

    Just wanted to say hello all. This is my first post.

    I expect to learn a ton here.

  8. sugardaddypiemom August 21, 2009 at 3:45 pm

    Hi there,

    I am up to date here and bit it would be decorous to introduce myself. I am a waitress, basically. Has nothing much to do with this here. But thought notable dominion hope for to know.

    Perhaps this despatch is soemwhat stupid. I resolution look how others do it and then improve.
    Until then, see fit respond and tell me what I can improve.

    So, Hi there!

  9. lampSkima August 13, 2009 at 11:14 am

    This look interesting,so far.
    If there are any real people here looking to network, leave me a post.
    Oh, and yes I’m a real person LOL.

    Peace,

  10. musicxroom June 29, 2009 at 3:58 pm

    hellooooooooo

  11. Runescape_hater June 21, 2009 at 5:21 pm

    Hey i just wanted to say hi to everyone.

  12. vickedrobert June 15, 2009 at 3:17 am

    I was reading free stuff forums a few days ago and found a
    company offering antiflu facemasks:
    ( link edited )
    What’s their reason to do it? Is it a scam or what?

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Advertise

If you'd like to advertise on The Mutt ( aka TheTAZZone.com ) feel free to contact us at: administration[at]thetazzone.com

TheTAZZone is a non-commercial entity. We do not sell any products or services ourselves. Our revenue comes from advertising and donations only.

We appreciate your support! Your advertising revenue ( or donations ) helps us to continue to upgrade, improve, and offset the costs of maintaining this site.

Donations can be made through the page ' Donate '.