<div dir="ltr">However, am thinking to do the following<br><br>mysqlhotcopy --allowold --flushlog -u <username> --password=<password> <dbname> /var/backups/mysql/<br><br>or <br><br>/usr/bin/mysqldump -u#### -p#### --all-databases -a > /var/backups/mysql/$(date +%Y%m%d).sql<br>
tar cf - /var/backups/mysql/$(date +%Y%m%d).sql | gzip -c > /misc/backups/MySQL/$(date +%Y%m%d).tar.gz<br><br>Any recommendation ,,,,,,,,<br><br><div class="gmail_quote">On Wed, Sep 3, 2008 at 9:06 PM, Jim Perrin <span dir="ltr"><<a href="mailto:jperrin@gmail.com">jperrin@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class="Ih2E3d">On Wed, Sep 3, 2008 at 2:45 PM, Mad Unix <<a href="mailto:madunix@gmail.com">madunix@gmail.com</a>> wrote:<br>
> I need to replicate MySQL DB of mulltiple server on SiteA to my DR-Site<br>
> Site_B... all DB<br>
> are alocated on RHEL,SuSE,Centos,Debian, FreeBSD servers.<br>
> I need a script to take Multiple MySql DataBase Backup and then import to<br>
> SiteB, the replica<br>
> can be done as cold or hotbackup and cron it<br>
> Thanks<br>
<br>
</div>I'm sure there are several folks on the list who would be willing to<br>
contract out for the creation of such a script. If you're looking for<br>
cheaper stuff though, you might want to have a look at maatkit or<br>
zmanda.<br>
<font color="#888888"><br>
<br>
--<br>
During times of universal deceit, telling the truth becomes a revolutionary act.<br>
George Orwell<br>
</font><div><div></div><div class="Wj3C7c">_______________________________________________<br>
CentOS mailing list<br>
<a href="mailto:CentOS@centos.org">CentOS@centos.org</a><br>
<a href="http://lists.centos.org/mailman/listinfo/centos" target="_blank">http://lists.centos.org/mailman/listinfo/centos</a><br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>Madunix_at_Gmail<br>Sysadmin<br><br>"Computers are useless. They can only give you answers" - Pablo Picasso<br>"Never trust a computer you can't throw out a window." - Steve Wozniak <br>
</div>