|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
October 15th, 2003, 10:43 AM
|
|||
|
|||
|
Backing Up WebServer & MySQL
I have multiple Virtual Hosts with multiple MySQL databases. What is the best way to back up webserver directories & SQL databases? Is there an easy way to mirror directories from one machine to another?
|
|
#2
October 15th, 2003, 07:10 PM
|
||||
|
||||
|
There are a lot of ways to backup a system.
rsync over ssh is about as easy, secure and resource-frugal as it gets. Code:
rsync -auvz -e ssh user@remote.host.com:/directory/to/backup/ /local/directory put in a cron job in hosts that have exchanged public keys and it will automatically back remote.host.com to the local system. Rsync is smart enough to only send the parts of files that have changed, as well. Very fast. mysqldump your databases into a path above, and you've got your mysql backups as well. Personally, I use a perl script that wraps around mysqldump, tar, gzip and ncftpput for my backups.
|
|
#3
October 15th, 2003, 08:14 PM
|
|||
|
|||
|
thanks
|
|
| Viewing: Dev Shed Forums > Other > Beginner Programming > Backing Up WebServer & MySQL |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
