Hi Felix (or anyone), I'm giving this a go but as a Linux newbie running Red hat 7.2 I have a question to ask ....
Do I need to alter anything in Cron for it to run the logrotate script? What would I need to put into the hourly cron folder to make things happen more often to check they are working correctly? Alex -----Original Message----- From: Felix Richter [mailto:[EMAIL PROTECTED]] Sent: 18 February 2002 15:26 To: David yahoo; mySQL List Subject: Re: **Backing Up A Database** - create a file in /etc/logrotate.d, filename does not matter, take this as a template, fill in connection parameters in mysqldump call ("xxxx"): /home/backup/sqlback/mybackup.sql { daily nomissingok nocreate compress rotate 14 errors [EMAIL PROTECTED] prerotate mysqldump xxxx --opt --full >/home/backup/sqlback/mybackup.sql endscript } - check syntax and options of this file: "man logrotate" - you're set: cron will call logrotate each night. logrotate processes each file in the dir, executes the prerotate script and then compresses the "log"file (i.e. SQL-Dump), renames older ones and keeps at max 14 of them ("rotate 14"). "nomissingok" will let you know if the mysqldump failed Felix --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.324 / Virus Database: 181 - Release Date: 14/02/2002 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.324 / Virus Database: 181 - Release Date: 14/02/2002 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php