Using RSYNC with MYSQL and ENSIM
cbyrum at spamaps.org
Mon Mar 28 19:22:51 GMT 2005
On Mon, 2005-03-28 at 13:15 -0600, Carlos Santillana wrote:
> 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
> 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
> Please advice, and thanks for the help.
Clint Byrum <cbyrum at spamaps.org>
More information about the rsync