Using RSYNC with MYSQL and ENSIM

Clint Byrum cbyrum at
Mon Mar 28 19:22:51 GMT 2005

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? 

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>

More information about the rsync mailing list