Web Hosting Talk







View Full Version : Mysql Daily Backup


Euperia
11-04-2002, 01:19 PM
Hi

I want to send a mysqldump > text.sql to a particular email address at intervals.

My .sh script when executed from the shell/ssh works great, but when set a a cron script in /etc/cron.daily it gives a permissions error on mysqldump.

Is there another way of sending a mysql backup to an email account?

Andrew

MarkIL
11-04-2002, 02:45 PM
How are you executing mysqldump?
What's the error?

Brakkar
11-04-2002, 07:57 PM
are you using the root user for mysqldump, could be the problem. I use this on my server and it seems to work well under cron.