automated database backup?

subodh · #1 (**permalink**) 05-27-2007, 09:37 AM

Is there any script available that make automatic backup of site database twice a week and email you that database backup is ready for download? For now I have to go to the site cpanel and do database backup manually.

yogesh · #2 (**permalink**) 05-27-2007, 05:42 PM

I one script that takes backup of the database and dumps it in a particular folder. Couldn’t find one that emails you the dump as well, here is the script I use www.adminfusion.com/forums/t2127/

India forum · #3 (**permalink**) 06-01-2007, 07:30 PM

Adminfusion is pretty old dude, i have find many.

Jay

exculiber · #4 (**permalink**) 06-24-2007, 05:31 PM

I heard about CRON job under Linux based web hosting. I don't know exactly how it is done. For those with experience maybe they can show the process.

tanja · #5 (**permalink**) 01-26-2009, 04:25 PM

Adminfusion is pretty old dude, i have find many.

Robdale · #6 (**permalink**) 02-06-2009, 06:00 PM

Hey buddy, I didn't get your question. Are you saying about the site's Mysql database? If so, then please follow the link...
http://www.debianhelp.co.uk/mysqlscript.htm

Hope this will help....

paradigmad · #7 (**permalink**) 06-03-2009, 06:38 PM

Are you using a platform like wordpress? if so there is a plugin for it. But there are lots of scripts to do what you are looking for. Try cpanel with cron jobs

pakidesigner · #8 (**permalink**) 06-29-2009, 11:33 AM

rubby on rails also does the job..i used it.

kris · #9 (**permalink**) 01-23-2010, 06:06 AM

Thanks for sharing information.Its usefull

prakask · #10 (**permalink**) 01-30-2010, 11:54 AM

Good one , I was looking for one. Thanks for the information and keep up good work.

danviettravel · #11 (**permalink**) 02-19-2010, 08:57 AM

Thanks a lot for sharing that information. It is really useful!
Keep up your good work!

Dontaejonas · #12 (**permalink**) 07-27-2010, 06:04 PM

Under Linux based web hosting, I have heard about CRON job. The way in which it is done is something I don’t know.

cpace32 · #13 (**permalink**) 08-08-2010, 06:52 PM

Look into using mysqldump, via cron. It should look something like this:

Code:

mysqldump -u root --password='your_password' --all-databases >/path/to/backups/mysql-`echo $DAY`.sql

This will backup your databases daily, saved by the day of the month.

jacksoncarrey · #14 (**permalink**) 08-13-2010, 04:04 PM

From the directory specified in configure automatic maintenance wizard, automatic backup feature will be regularly delete backup images if backup to disk is chosen.

MATHEW · #15 (**permalink**) 06-23-2011, 11:34 AM

I have one script (www.adminfusion.com/forums/t2127/) that takes backup of the database and dumps it in a particular folder.