[CentOS] mysql

[Mad Unix]

However,  am thinking to do the following

mysqlhotcopy --allowold --flushlog -u <username> --password=<password>
<dbname> /var/backups/mysql/

or

/usr/bin/mysqldump -u#### -p#### --all-databases -a >
/var/backups/mysql/$(date +%Y%m%d).sql
tar cf - /var/backups/mysql/$(date +%Y%m%d).sql | gzip -c >
/misc/backups/MySQL/$(date +%Y%m%d).tar.gz

Any recommendation ,,,,,,,,

On Wed, Sep 3, 2008 at 9:06 PM, Jim Perrin <jperrin at gmail.com> wrote:

> On Wed, Sep 3, 2008 at 2:45 PM, Mad Unix <madunix at gmail.com> wrote:
> > I need to replicate MySQL DB of mulltiple server on SiteA to my DR-Site
> > Site_B... all DB
> > are alocated on RHEL,SuSE,Centos,Debian, FreeBSD servers.
> > I need a script to take Multiple MySql DataBase Backup and then import to
> > SiteB, the replica
> > can be done as cold or hotbackup and cron it
> > Thanks
>
> I'm sure there are several folks on the list who would be willing to
> contract out for the creation of such a script. If you're looking for
> cheaper stuff though, you might want to have a look at maatkit or
> zmanda.
>
>
> --
> During times of universal deceit, telling the truth becomes a revolutionary
> act.
> George Orwell
> _______________________________________________
> CentOS mailing list
> CentOS at centos.org
> http://lists.centos.org/mailman/listinfo/centos
>



-- 
Madunix_at_Gmail
Sysadmin

"Computers are useless. They can only give you answers" - Pablo Picasso
"Never trust a computer you can't throw out a window." - Steve Wozniak
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.centos.org/pipermail/centos/attachments/20080904/b547867b/attachment.html>