<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word" xmlns:st1 =
"urn:schemas-microsoft-com:office:smarttags"><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.19120"><o:SmartTagType
name="City"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
name="place"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><!--[if !mso]>
<STYLE>st1\:* {
BEHAVIOR: url(#default#ieooui)
}
</STYLE>
<![endif]-->
<STYLE>@page Section1 {size: 595.3pt 841.9pt; margin: 72.0pt 90.0pt 72.0pt 90.0pt; }
P.MsoNormal {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"; FONT-SIZE: 12pt
}
LI.MsoNormal {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"; FONT-SIZE: 12pt
}
DIV.MsoNormal {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"; FONT-SIZE: 12pt
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.EmailStyle17 {
FONT-FAMILY: Arial; COLOR: windowtext; mso-style-type: personal
}
SPAN.EmailStyle21 {
FONT-FAMILY: Arial; COLOR: navy; mso-style-type: personal-reply
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=EL link=blue vLink=purple>
<DIV dir=ltr align=left>
<DIV dir=ltr align=left><SPAN class=997272511-05102011><FONT color=#0000ff
size=2 face=Arial>Hi,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=997272511-05102011><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=997272511-05102011><FONT color=#0000ff
size=2 face=Arial>the problem is to lock the databases to get a consistent
backup.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=997272511-05102011><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=997272511-05102011><FONT color=#0000ff
size=2 face=Arial>You'd be better off asking <A
href="http://www.google.de/#q=mysql+backup"><FONT size=3
face="Times New Roman">http://www.google.de/#q=mysql+backup</FONT></A> .</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=997272511-05102011><FONT color=#0000ff
size=2 face=Arial>Maybe using a simple mysqldump + transferring the dump to
a backup server would</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=997272511-05102011><FONT color=#0000ff
size=2 face=Arial>meet your requirements<SPAN class=149442711-05102011> (for
this, you could use rsync, of course ;-)</SPAN>.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=997272511-05102011><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=997272511-05102011><FONT color=#0000ff
size=2 face=Arial>Have a nice day,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=997272511-05102011><FONT color=#0000ff
size=2 face=Arial>Berny</FONT></SPAN></DIV><BR></DIV><BR>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B> rsync-bounces@lists.samba.org
[mailto:rsync-bounces@lists.samba.org] <B>On Behalf Of </B>Charalampos
Gkevrekis<BR><B>Sent:</B> Wednesday, October 05, 2011 12:08 PM<BR><B>To:</B>
rsync@lists.samba.org<BR><B>Subject:</B> Require
Information<BR><B>Importance:</B> High<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV class=Section1>
<DIV>
<P class=MsoNormal><FONT size=2 face=Arial><SPAN
style="FONT-FAMILY: Arial; FONT-SIZE: 10pt" lang=EN-US>Hi
there!<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT size=2 face=Arial><SPAN
style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"
lang=EN-US><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT size=2 face=Arial><SPAN
style="FONT-FAMILY: Arial; FONT-SIZE: 10pt" lang=EN-US>I would like to ask
kindly for some further information concerning Rsync
software.<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT size=2 face=Arial><SPAN
style="FONT-FAMILY: Arial; FONT-SIZE: 10pt" lang=EN-US>What I am planning to do
is to replicate data (database) at certain
intervals.<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT size=2 face=Arial><SPAN
style="FONT-FAMILY: Arial; FONT-SIZE: 10pt" lang=EN-US>My first question is, can
I do this with Rsync?<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT size=2 face=Arial><SPAN
style="FONT-FAMILY: Arial; FONT-SIZE: 10pt" lang=EN-US>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.<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT size=2 face=Arial><SPAN
style="FONT-FAMILY: Arial; FONT-SIZE: 10pt" lang=EN-US>In other words I need to
setup a backup process for this database in real time.
<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT size=2 face=Arial><SPAN
style="FONT-FAMILY: Arial; FONT-SIZE: 10pt" lang=EN-US>Could anyone tell me if I
can do this with Rsync and give me a clue how can I implement
this?<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT size=2 face=Arial><SPAN
style="FONT-FAMILY: Arial; FONT-SIZE: 10pt" lang=EN-US>Thanks in
advance.<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT size=2 face=Arial><SPAN
style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"
lang=EN-US><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT size=2 face=Arial><SPAN
style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"
lang=EN-US>Regards,<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT size=2 face=Arial><SPAN
style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"
lang=EN-US><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT size=3 face=Arial><SPAN
style="FONT-FAMILY: Arial; FONT-SIZE: 12pt" lang=EN-GB>Charalampos
Gkevrekis</SPAN></FONT><SPAN lang=EN-GB><o:p></o:p></SPAN></P>
<P class=MsoNormal><EM><I><FONT size=3 face="Times New Roman"><SPAN
style="FONT-SIZE: 12pt" lang=EN-GB>System
Administrator</SPAN></FONT></I></EM><SPAN lang=EN-GB><o:p></o:p></SPAN></P>
<P class=MsoNormal><FONT size=3 face="Times New Roman"><SPAN
style="FONT-SIZE: 12pt" lang=EN-GB> <o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><STRONG><B><I><FONT size=2 face=Arial><SPAN
style="FONT-STYLE: italic; FONT-FAMILY: Arial; FONT-SIZE: 10pt"
lang=EN-GB>Center for Renewable Energy Sources and
Saving</SPAN></FONT></I></B></STRONG><SPAN lang=EN-GB><o:p></o:p></SPAN></P>
<P class=MsoNormal><EM><I><FONT size=1 face="Times New Roman"><SPAN
style="FONT-SIZE: 7.5pt" lang=EN-GB>Energy Information Systems & Planning
Dept</SPAN></FONT></I></EM><SPAN lang=EN-GB><o:p></o:p></SPAN></P>
<P class=MsoNormal><FONT color=blue size=2 face=Arial><SPAN
style="FONT-FAMILY: Arial; COLOR: blue; FONT-SIZE: 10pt"><A
href="http://www.cres.gr/"><EM><I><FONT color=black size=3 face=Arial><SPAN
style="FONT-FAMILY: Arial; COLOR: windowtext; FONT-SIZE: 12pt; TEXT-DECORATION: none"
lang=EN-GB>www.cres.gr</SPAN></FONT></I></EM></A></SPAN></FONT><SPAN
lang=EN-GB><o:p></o:p></SPAN></P>
<P class=MsoNormal><FONT size=3 face="Times New Roman"><SPAN
style="FONT-SIZE: 12pt" lang=EN-GB> <o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><STRONG><B><FONT size=2 face=Arial><SPAN
style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"
lang=EN-GB>E-mail</SPAN></FONT></B></STRONG><EM><I><FONT
face="Times New Roman"><SPAN lang=EN-GB>: </SPAN></FONT></I></EM><A
href="mailto:cgkevrek@cres.gr"><EM><I><FONT color=black
face="Times New Roman"><SPAN style="COLOR: windowtext; TEXT-DECORATION: none"
lang=EN-GB>cgkevrek@cres.gr</SPAN></FONT></I></EM></A><SPAN
lang=EN-GB><o:p></o:p></SPAN></P>
<P class=MsoNormal><STRONG><B><FONT size=2 face=Arial><SPAN
style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"
lang=EN-GB>Telephone:</SPAN></FONT></B></STRONG><EM><I><FONT
face="Times New Roman"><SPAN lang=EN-GB> (+30)210
6603330</SPAN></FONT></I></EM><SPAN class=msonormalstyle16style170><FONT size=2
face=Arial><SPAN style="FONT-FAMILY: Arial; FONT-SIZE: 10pt" lang=EN-GB>
</SPAN></FONT></SPAN><SPAN lang=EN-GB><o:p></o:p></SPAN></P>
<P class=MsoNormal><st1:place w:st="on"><st1:City w:st="on"><STRONG><B><FONT
size=2 face=Arial><SPAN style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"
lang=EN-GB>Mobile</SPAN></FONT></B></STRONG></st1:City></st1:place><STRONG><B><FONT
size=2 face=Arial><SPAN style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"
lang=EN-GB>:</SPAN></FONT></B></STRONG><SPAN
class=msonormalstyle16style170><FONT size=2 face=Arial><SPAN
style="FONT-FAMILY: Arial; FONT-SIZE: 10pt" lang=EN-GB>
</SPAN></FONT></SPAN><EM><I><FONT face="Times New Roman"><SPAN
lang=EN-GB>(+30)6945 237506</SPAN></FONT></I></EM><SPAN
lang=EN-GB><o:p></o:p></SPAN></P>
<P class=MsoNormal><STRONG><B><FONT size=2 face=Arial><SPAN
style="FONT-FAMILY: Arial; FONT-SIZE: 10pt" lang=EN-GB>IM
MSN:</SPAN></FONT></B></STRONG><EM><I><FONT face="Times New Roman"><SPAN
lang=EN-GB> </SPAN></FONT></I></EM><SPAN class=msonormalstyle16style170><A
href="mailto:hgkevrekis@hotmail.com"><EM><I><FONT color=black
face="Times New Roman"><SPAN style="COLOR: windowtext; TEXT-DECORATION: none"
lang=EN-GB>hgkevrekis@hotmail.com</SPAN></FONT></I></EM></A></SPAN><SPAN
lang=EN-GB><o:p></o:p></SPAN></P>
<P class=MsoNormal><STRONG><B><FONT size=2 face=Arial><SPAN
style="FONT-FAMILY: Arial; FONT-SIZE: 10pt" lang=EN-GB>IM
Yahoo:</SPAN></FONT></B></STRONG><EM><I><FONT face="Times New Roman"><SPAN
lang=EN-GB> </SPAN></FONT></I></EM><SPAN class=msonormalstyle16style170><A
href="mailto:hgkevrekis@yahoo.gr"><EM><I><FONT color=black
face="Times New Roman"><SPAN style="COLOR: windowtext; TEXT-DECORATION: none"
lang=EN-GB>hgkevrekis@yahoo.gr</SPAN></FONT></I></EM></A></SPAN><SPAN
lang=EN-GB><o:p></o:p></SPAN></P>
<P class=MsoNormal><STRONG><B><FONT size=2 face=Arial><SPAN
style="FONT-FAMILY: Arial; FONT-SIZE: 10pt" lang=EN-GB>IM
Gtalk:</SPAN></FONT></B></STRONG><EM><I><FONT face="Times New Roman"><SPAN
lang=EN-GB> </SPAN></FONT></I></EM><SPAN class=msonormalstyle16style170><A
href="mailto:gkevrekis@gmail.com"><EM><I><FONT color=black
face="Times New Roman"><SPAN style="COLOR: windowtext; TEXT-DECORATION: none"
lang=EN-GB>gkevrekis@gmail.com</SPAN></FONT></I></EM></A></SPAN><SPAN
lang=EN-GB><o:p></o:p></SPAN></P>
<P class=MsoNormal><FONT size=3 face="Times New Roman"><SPAN
style="FONT-SIZE: 12pt" lang=EN-GB> <o:p></o:p></SPAN></FONT></P></DIV>
<P class=MsoNormal><FONT size=3 face="Times New Roman"><SPAN
style="FONT-SIZE: 12pt"
lang=EN-GB><o:p> </o:p></SPAN></FONT></P></DIV></BODY></HTML>