Re: mysql

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx>

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


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

mysqlhotcopy --allowold --flushlog -u &lt;username> --password=&lt;password>
&lt;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@xxxxxxx> 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@xxxxxxxxxx?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@xxxxxxxxxx?subject=unsubscribe
https://www.redhat.com/mailman/listinfo/redhat-list

-- 
redhat-list mailing list
unsubscribe mailto:redhat-list-request@xxxxxxxxxx?subject=unsubscribe
https://www.redhat.com/mailman/listinfo/redhat-list

[Index of Archives]     [CentOS]     [Kernel Development]     [PAM]     [Fedora Users]     [Red Hat Development]     [Big List of Linux Books]     [Linux Admin]     [Gimp]     [Asterisk PBX]     [Yosemite News]     [Red Hat Crash Utility]


  Powered by Linux