Hi,
the problem is to lock the databases to get a consistent backup.
You'd be better off asking http://www.google.de/#q=mysql+backup .
Maybe using a simple mysqldump + transferring the dump to a backup server would
meet your requirements (for this, you could use rsync, of course ;-).
Have a nice day,
Berny
________________________________
From: rsync-bounces at lists.samba.org [mailto:rsync-bounces at lists.samba.org]
On Behalf Of Charalampos Gkevrekis
Sent: Wednesday, October 05, 2011 12:08 PM
To: rsync at lists.samba.org
Subject: Require Information
Importance: High
Hi there!
I would like to ask kindly for some further information concerning Rsync
software.
What I am planning to do is to replicate data (database) at certain intervals.
My first question is, can I do this with Rsync?
To be more specific I have a mysql database at a point and I want this database
to be replicated to a remote side at real-time.
In other words I need to setup a backup process for this database in real time.
Could anyone tell me if I can do this with Rsync and give me a clue how can I
implement this?
Thanks in advance.
Regards,
Charalampos Gkevrekis
System Administrator
Center for Renewable Energy Sources and Saving
Energy Information Systems & Planning Dept
www.cres.gr<http://www.cres.gr/>
E-mail: cgkevrek at cres.gr<mailto:cgkevrek at cres.gr>
Telephone: (+30)210 6603330
Mobile: (+30)6945 237506
IM MSN: hgkevrekis at hotmail.com<mailto:hgkevrekis at hotmail.com>
IM Yahoo: hgkevrekis at yahoo.gr<mailto:hgkevrekis at yahoo.gr>
IM Gtalk: gkevrekis at gmail.com<mailto:gkevrekis at gmail.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.samba.org/pipermail/rsync/attachments/20111005/c07aa202/attachment.html>