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