Book Image

phpBB: A User Guide

Book Image

phpBB: A User Guide

Overview of this book

phpBB is a free, open source Internet community application, with outstanding discussion forums and membership management. Written in the PHP scripting language, and making use of the popular MySQL database, phpBB is a standard among web hosting companies throughout the world, and is one of the most widely-used bulletin board packages in the world. This book is an abridged version of "Building Online Forums with phpBB 2", (ISBN 1904811132), focusing on a complete set of topics to help you set up and run your own phpBB-powered online community. This book gives you the power to use phpBB to set up and run your own online discussion forums with ease. It takes you through the whole process of setting up your phpBB site, and helps you create, customize, and manage your own online community with phpBB. Written by experienced phpBB administrators and enthusiasts, the emphasis is on simple and practical guidance for you to get the most from phpBB. Packed with step-by-step examples, this book is your ideal guide to learning phpBB.
Table of Contents (11 chapters)

Second Look into Database Backups and Restore


You already know how to use phpBB’s backup and restore utilities. It was mentioned that they might not work as expected, if you have a very big database and your hosting provider has set some rules on server resources usage. So now let’s take a look at using other means of achieving the same result. MySQL is the RDBMS used in this section; it’s the most popular to run phpBB on.

Using phpMyAdmin

phpMyAdmin can be used for backing up and restoring you forum database. It has an export utility that can help you create an SQL dump of a table or a database or even all the databases on a server. An SQL dump is a text file that contains all the necessary SQL commands needed to create a copy of a table or a database. phpBB’s database backup and restore utility uses the same SQL dumps.

If you’re feeling nosy you can open an SQL dump with a text editor, and you’ll see a whole bunch of SQL commands that start like this:

-- phpMyAdmin SQL Dump
-- version 2...