Support Forum Articles File Help Startup DB Tips Service DB Hijack This! Analyzer

 

MySQL Automated offsite backup
Step 3: backup.bat

right click on backup.bat and select edit. Replace E:\ftp.cmd with wherever you've placed the file. Insert the following into the file:

ftp -s:e:\ftp.cmd

Step 4: ftp.cmd

Right click on ftp.cmd and select edit. Insert the following (bold means customize):

open SERVER
USER
PASS
cd LOCATION
get FILE.sql.gz

Step 5: Customize

SERVER will either be an IP or the domain name of the FTP address you're connecting to.
USER is the username needed to log into the FTP
PASS is the password required to log into the FTP
LOCATION may or may not be needed depending on the default path when you log in. Most people will need to change to the appropriate directory.
FILE is of course the name of the file you'd like to automatically download.

Step 6: Schedule It

Start --> Settings --> Control Panel --> Scheduled Tasks --> Add new task

Simply follow the wizard and you're done! On a site as massive as this one I only do weekly backups to my office system with daily backups on the server.


Written By: Martin Krohn
Date: 7-30-04
Views: 9523
Printer Friendly

Article Index:
Talk About it! -->