O'Reilly logo

Building Online Communities with phpBB 2 by Stoyan Stefanov, Mike Lothar, Jeremy Rogers

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required