mysql

[Ryan Golhar]

# dump the database
mysqldump -u root --password=<password> --databases <list of databases 
to backup> | gzip > /root/backup/mysql.sql.gz
# copy the gzip file elsewhere
scp /root/backup/mysql.sql.gz <new location>


chaim.rieger at gmail.com wrote:
> 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
>>
> 
> 
>