Re: mysql

[Ryan Golhar <golharam@xxxxxxxxx>]

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