Using RSYNC with MYSQL and ENSIM

[Clint Byrum]

On Mon, 2005-03-28 at 13:15 -0600, Carlos Santillana wrote:
> Team,
> 
> Im im new on this forum and with RSYNC, i have a Server that im using for 
> hosting my own subdomains, using Ensim and MYSQL, but i have another server 
> that o would like to be my backup server.. (FYI: I have 2 License of the 
> Ensim)
> 
> My questions are:
> 
> 1.- Can i use Rsync to backup my primary server to the secondary server? 
> MYSQL, ENSIM?
> 

I've used rsync to transfer MyISAM databases before, and it works
flawlessly as long as you do something like 'FLUSH TABLES WITH READ
LOCK;' on the master server. For InnoDB... I don't think it should be a
problem, but you will probably have to shut down mysqld to do the rsync.

> 2.- If so how would i do it? Do i just do a whole copy of the server from 
> root?
> 
> Please advice, and thanks for the help.
> 
> 
-- 
Clint Byrum <cbyrum at spamaps.org>