mysql

chaim.rieger at gmail.com chaim.rieger at gmail.com
Thu Sep 4 07:33:18 UTC 2008


I've used dump and still do on a regular basis. Never failed me yet


Sent via BlackBerry from T-Mobile

-----Original Message-----
From: "Mad Unix" <madunix at gmail.com>

Date: Thu, 4 Sep 2008 09:29:31 
To: General Red Hat Linux discussion list<redhat-list at redhat.com>
Subject: Re: mysql


However, am thinking to do this script and run it on the colrintab

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 input about the above....

Thanks


On Wed, Sep 3, 2008 at 2:43 PM, mark <m.roth2006 at rcn.com> wrote:

> Mad Unix wrote:
> > I need a script to take Multiple MySql DataBase Backup export Script for
> > Linux then import them to other server
> > to make them symmetric !
>
> export's a std. feature. The real question is hot or cold b/u?
>
>        mark
>
> --
> redhat-list mailing list
> unsubscribe mailto:redhat-list-request at redhat.com?subject=unsubscribe
> https://www.redhat.com/mailman/listinfo/redhat-list
>



-- 
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
-- 
redhat-list mailing list
unsubscribe mailto:redhat-list-request at redhat.com?subject=unsubscribe
https://www.redhat.com/mailman/listinfo/redhat-list




More information about the redhat-list mailing list