could it be posible to make or add a sort of function in the preferences to make a daily back up of the data base and be sent to an email addrress, if so that could i t be very attractive

TRANCEBUDHA wrote:

could it be posible to make or add a sort of function in the preferences to make a daily back up of the data base and be sent to an email addrress, if so that could i t be very attractive

Or auto set for backups to be made at a certain time and to cascade files such as
BackupApr01
BackupApr02
BackupApr03
BackupApr04

Been looking for this option.

I hope you have a verry large email box

cronjobs is a way to do it, and i use this shellbatch to do it

Code::

#! /bin/sh FILE=cpgcms-`date +%Y%m%d%H%M`.sql DIR=/PATH/TO/backup/DIR/`date +%Y%m%d`/ mkdir ${DIR} mysqldump -f -hSERVERIP -uUSERNAME -pPASSWORD DBNAME --add-drop-table | gzip -9c >${DIR}${FILE}.gz uuencode ${DIR}${FILE}.gz ${FILE}.gz | mail WEBMASTER @ MYSITE.COM

This is exactly what I would like to setup.

Could someone help me convert DJMaze's example script into a working one?

Code::

#! /bin/sh

Does this get left alone?

Code::

FILE=cpgcms-`date +%Y%m%d%H%M`.sql

I gather this is the filename it will save as?

Code::

DIR=/PATH/TO/backup/DIR/`date +%Y%m%d`/

Which directory do I need to setup here? The path to where I want the backup saved? Does it get deleted when it's been emailed? e.g. would a correct line look like-

Code::

DIR=/home/norbie/backups/`date +%Y%m%d`/

Does it need to be in the www folder?

Code::

mkdir ${DIR}

I imagine nothing needs changing here again?

Code::

mysqldump -f -hSERVERIP -uUSERNAME -pPASSWORD DBNAME --add-drop-table | gzip -9c >${DIR}${FILE}.gz

Do I keep the -h and -u and -p infront of my username and password when I have filled them in? How come the DBNAME section doesn't have a letter in front of it?

Code::

uuencode ${DIR}${FILE}.gz ${FILE}.gz | mail WEBMASTER @ MYSITE.COM

And here I just enter my email address?

Sorry there's so many questions, I just wanna get this cool feature working!
I would look in the old Geek Forums, but it seems to be disabled!

Thanks to anyone who can spare a little time!

first line is Required.
if you had it in www folder, they could see it unless they know file name.
replace SERVERIP to host mysql domain
replace USERNAME to user name that you set up for that database
replace PASSWORD to password that associated to DB user that you setup
replace DBNAME to Database name you setup
replace WEBMASTER @ MYSITE.COM to Email Address

Thanks xfsunoles,

I'll give that a go when the next hour (00 minutes) comes up

For the email address, does it needs a space between the @ symbol? Or is that just how the filter works here?

norbie wrote:

Thanks xfsunoles, I'll give that a go when the next hour (00 minutes) comes up For the email address, does it needs a space between the @ symbol? Or is that just how the filter works here?

it propably doesn't need space.

thanks! fingers crossed, i should be getting an email in a few minutes!

I'm afraid it didn't work again

Code::

#! /bin/sh FILE=cpgcms-`date +%Y%m%d%H%M`.sql DIR=/home5/sub003/sc12413-VFUZ/www/cronjobs/backups/`date +%Y%m%d`/ mkdir ${DIR} mysqldump -f -hHOST -uUSER -pPASS DBNAME --add-drop-table | gzip -9c >${DIR}${FILE}.gz uuencode ${DIR}${FILE}.gz ${FILE}.gz | mail cronjobs @ me.co.uk

That's how I have it setup, and in my control panel -


Do you see anything obviously wrong?

Does anyone have any tips for this? *This is in the wrong forum*