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