On Fri, 20 Dec 2002, Jim wrote: > I decided that one way to back up a database is to write a bash script to run > mysqldump. I know that I can put the script in /etc/cron.weekly and have it > execute every week. My question is what user will the cron job run as? Cron runs as root, but you should be able to do something like: su - mysqluser -c "mysqldump mydatabase > /someplace/mydatabase.sql"