Results 1 to 3 of 3
Thread: offsite backups?
Hybrid View
-
05-13-2011, 05:41 PM #1Temporarily Suspended
- Join Date
- Dec 2009
- Posts
- 122
offsite backups?
So I have 2 virtual servers. I would want to use one for backup. Im interested only in MySQL backup on a remote SSH(2nd VPS). Anyone got some script for that?
-
05-13-2011, 10:06 PM #2Web Hosting Guru
- Join Date
- Mar 2005
- Location
- Maine, USA
- Posts
- 311
Here's one example script that I have used. Note the script has your password in it, so if someone gets ahold of the script, :|
Make sure to chmod 600 mysqlbackup.sh script file.
You'll also want to set up passwordless SSH logins via keys:
http://www.petefreitag.com/item/532.cfm
Code:#!/bin/bash DBNAME=databasename DBUSER=databaseuser DBPASS=password DATE=`date +%Y%m%d` mysqldump --opt -u $DBUSER -p$DBPASS $DBNAME > /home/username/mysql/mysql-database-username-backup-$DATE.sql tar -cz -C / home/username/mysql/mysql-database-username-backup-$DATE.sql > /home/username/mysql/mysql-database-username-backup-$DATE.sql.tar.gz rm /home/username/mysql/mysql-database-username-backup-$DATE.sql scp mysql-database-username-backup-$DATE.sql.tar.gz user@remote.server2.com:/home/user/whereyoustoreyourbackups/
-
05-14-2011, 01:59 AM #3Newbie
- Join Date
- May 2011
- Posts
- 17
Similar Threads
-
Offsite Backups
By GarrettReardon in forum Hosting Security and TechnologyReplies: 6Last Post: 08-27-2009, 03:51 PM -
anyone have offsite backups?
By rubberman in forum Dedicated ServerReplies: 11Last Post: 07-20-2005, 03:56 PM -
Offsite backups?
By drsprite in forum Dedicated ServerReplies: 5Last Post: 02-08-2004, 09:46 PM