Chapter 40 of 43 · The Admin Panel (Administrators)

Database Backups

A backup takes one click. Make one before any large change, and download it to your computer.

PHP Business Directory 6.1 · 1 min read · Download the manual as PDF

Admin Panel › Settings › Backups

The Backups page saves a complete copy of the database: listings, users, reviews, pages, news, settings and everything else stored in it.

System Backups.
Figure 40.1 System Backups.

Creating and downloading a backup

  1. Click Generate New Backup. The backup is created as an .sql file with the date and time in its name.
  2. It appears in Available Backups. Click the download button to save it on your computer.
  3. Delete old backups from the server from time to time; they contain your users' personal data.

The backup contains the database only, not the uploaded photos, logos and banners, nor the program files. Back up the uploaded_images and thumbnails folders with FTP or your hosting control panel.

Restoring a backup

To restore, open phpMyAdmin, select the directory's database and import the .sql file. This replaces the current data with the data in the backup, so make a fresh backup of the current state first.

A simple backup routine

  • Before any large change: a database backup plus a copy of the uploaded images.
  • Every week: a database backup, downloaded to your computer or cloud storage.
  • Check that your hosting company also makes automatic backups, and how long it keeps them.