Here's a little tweak to gzip the backup results. I put this into another script
that gets called by crontab. Are my DB userid and password still visible when
run this way? I'm never here to see it run, because it happens late at night.

/usr/bin/mysqldump --user=DBUSER --password=DBPASSWORD DATABASETOBACKUP | gzip >

-----Original Message-----
From: Tobyn Baugher [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 03, 2002 1:29 PM
Subject: Re: [PHP] OT - php/mysql/cron

On Mon, 2002-06-03 at 13:18, Kelly Meeks wrote:
> Any way to use cron to automate the mysqldumping of databases on a nighly
> Any examples would be greatly appreciated.

This line's gonna wrap, but it all goes on the same line :P

0 0 * * * /usr/local/bin/mysqldump -u <username> --password=<password>
<database> > <outputfile>

Obviously replace <username>, <password>, <database>, and <outputfile>
with the values you want to use for each.

Of course, I would never recommend putting a "secure" password in a text
file like your crontab, so if you have admin rights on the server maybe
consider setting up a read-only account with no password, or maybe a
unique password that won't work on any other accounts.

Never hurts to be a little paranoid.



PHP General Mailing List (
To unsubscribe, visit:

PHP General Mailing List (
To unsubscribe, visit:

Reply via email to