mysql

[Mad Unix]

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