Re: Redundent Debian linux web server

> # Secure copy the database to the remote server
> scp /var/backup/DBBACKUP-$date.sql.bz2
> root@backupserver:/var/backup/DBBACKUP-$date.sql.bz2
>
> # Run a command on the remote server to decompress the database from the bzip2
> file.
> ssh -t root@backupserver bzip2 -d /var/backup/DBBACKUP-$date.sql.bz2
>
> # Import the decompressed file into mysql (takes a while!)
> ssh -t root@backupserver "mysql -DDBNAME -uUSERNAME -pPASSWORD <
> /var/backup/DBBACKUP-$date.sql"

Its probably faster to use rsync instead of scp. As well it might be
faster to not bzip it, and rsync. Depends on the cpu/network/disk
trade off you want to do.
Received on Thu Jul 27 11:15:47 2006