Database Backup

Introduction

AutoGallery SQL's database backup function allows you to output all of the MySQL database information to a text file so that the database can be repaired if necessary. It will also backup your datafiles that contain your blacklist, rejection e-mails, reciprocal links, icons, and TGP page HTML.

Backing Up Your Database

To backup your database, locate and click on the Backup Database link in the Setup section of the control panel menu. AutoGallery SQL will then display a page where you can enter the filenames you want to use for your backup files. Once you have entered the filenames you want to use, click on the Backup button. The backup process may take a few minutes, so be sure to give it time to complete.

To download the backup file for safe keeping, FTP into your server and change into the data directory of your AutoGallery SQL installation. Locate the two backup files you specified when you ran the backup function. You can download these files to your local computer for safe keeping. When transferring the datafile backup file (defaults to data.txt), make sure you transfer it in binary mode, not ASCII.

Restoring Your Database

To retore your database, locate and click on the Backup Database link in the Setup section of the control panel menu. AutoGallery SQL will then display a page where you can enter the filenames of your backup files. Make sure you have uploaded both of the backup files to the data directory of your AutoGallery SQL installation. When transferring the datafile backup file (defaults to data.txt), make sure you transfer it in binary mode, not ASCII. Once you have entered the filenames, click on the Restore button. AutoGallery SQL will begin importing the data from your files. This process may take a few minutes, so be sure to give it time to complete. After enough time has elapsed, you can continue using the software as usual.