[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [cobalt-users] MySQL backup script
- Subject: Re: [cobalt-users] MySQL backup script
- From: Pitr <pitr@xxxxxxxxx>
- Date: Wed May 21 04:53:17 2003
- List-id: Mailing list for users to share thoughts on Sun Cobalt products. <cobalt-users.list.cobalt.com>
Interesting scripts. I use:
/usr/bin/mysqldump -A -r /home/mysql/alldbs
via a 2:00 AM cronjob. All databases/tables in the mysql DB are dumped
to the /home/mysql/alldbs file. I'm not worried about doing a diff, I'd
rather just have the full backup everyday. Additionally, that command
dumps the data out into a sort of script fashion, in that you can pretty
much just execute the alldbs file in mysql and it will rebuild all
databases, tables and data from an empty or fresh install. If you want
to reinstall only a portion of the data, or a particular table you can
pick out that portion.
If your MySQL db is extremely huge then you might want to try other
dump/backup options that make it easier to restore only a subset of the
data more elegantly.
On Tue, 2003-05-20 at 20:51, Bruce Timberlake wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Found this site in my travels today; contains MySQL backup scripts
> (apparently) for a RaQ...
>
> http://www.aquarionics.com/journal/id/750