On Mon, 2003-07-21 at 10:57, Judson Lester wrote:
> On Monday, July 21, 2003, at 09:48 AM, David wrote:
>
> > Greetings All:
> >
> > Well I used some of Ron's recommendations, as far as giving the dump a
> > good file name and using scp. Then tar/gzip contents of mysqldump to a
> > tmp directory. Finally, scp puts the archive on my ftp server every
> > four hours via cron.
> > Thanks again!
>
> Right now:
>
> Consider carefully how you're going to prevent your backups from
> consuming all your disk space over time. Any unbounded disk
> consumption will eventually use up all your disk space.
>
> Probably your best bet in this situation is to reuse filenames in a
> loop. Instead of giving everything a perfectly unique name, name them
> with the number of the weekday, or the day of the month, so that the
> newest backup will overwrite the oldest. (This will also require
> whatever options set to compel overwrites.)
Or, his script (with a little help from Perl) could calculate
"15 days ago", and delete the that file.
-- +-----------------------------------------------------------------+ | Ron Johnson, Jr. Home: ron.l.johnson@cox.net | | Jefferson, LA USA | | | | "I'm not a vegetarian because I love animals, I'm a vegetarian | | because I hate vegetables!" | | unknown | +-----------------------------------------------------------------+ ___________________ Nolug mailing list nolug@nolug.orgReceived on 07/21/03
This archive was generated by hypermail 2.2.0 : 12/19/08 EST