Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Save more on your purchases now! discount-offer-chevron-icon
Savings automatically calculated. No voucher code required
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
phpBB: A User Guide

You're reading from   phpBB: A User Guide Set up and run your own discussion forum

Arrow left icon
Product type Book
Published in Feb 2006
Publisher Packt
ISBN-13 9781904811916
Pages 340 pages
Edition 1st Edition
Languages
Concepts
Arrow right icon
Authors (2):
Arrow left icon
Stoyan STEFANOV Stoyan STEFANOV
Author Profile Icon Stoyan STEFANOV
Stoyan STEFANOV
Jeremy Rogers Jeremy Rogers
Author Profile Icon Jeremy Rogers
Jeremy Rogers
Arrow right icon
View More author details
Toc

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

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at €18.99/month. Cancel anytime