I need to backup automatically daily my database in mysql and all image files on the server.
Is there a way to backup these things and send it on my email address ?
+3
A:
You can write a bash script that contains gzip, mysqldump and mail commands and have it run daily via cron job.
Salman A
2010-05-22 09:01:55
That's a good idea. BUT what happens when database and images folder gets too big?
Mihai Iorga
2010-05-22 11:13:40
I've been using shell script+cron to generate mysqldump of a database that's ~750MB in size till date, the sql zips down to ~10MB. The script runs every 8 hours, no problems so far. Can't say anything about files.
Salman A
2010-05-22 12:16:38