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. Important Download InstructionsWhen transferring the datafile backup file (defaults to data.txt), make sure you transfer it in binary mode, not ASCII.

Note that the backup process does not backup your script page templates or the preview thumbnails for your galleries. To backup your script page templates download the following files from the templates directory of your AutoGallery SQL installation: To backup your preview thumbnails you will need to download all of the files from the directory where your preview thumbnails are stored on your server.

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. Important Upload Instructions 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.

If you have made backups of your script page templates and your preview thumbnails, you will need to upload those now. Make sure you upload the template files in ASCII mode and the preview thumbnails in binary mode. Set the permissions on the template files and preview thumbnails to 666.