MySQL Automatic Backups

Carey Archer · 10-07-2008, 07:08 AM

Hi All,

Have all these great sites and blogs and dreaming (nightmare) about my Hosting falling over in the current climate.

What is the best way that I can do the automatic backups for MySQL, as the manual process is a full time job?

Thanks plenty.

Carey

Sean Kelly · 10-14-2008, 03:53 PM

Hi Carey, you can use the mysqldump command to do a database export.

Put that command along with your login info and database name and output filename into a .sh file.
Then create a cron job that runs every night that calls this script.

Make sure the script runs ok first before adding it to a nightly cron.
Also remember that every time it runs it will overwrite the previous backup file unless you add a timestamp to the filename.

Sean

Carey Archer · 10-27-2008, 08:56 AM

Thanks Guys, appreciate your help.

Carey Archer · 10-28-2008, 12:26 AM

What it is that I am after is a recommendation for something that is a gui based tool to backup multiple sites/databases remotely, any suggestions?

Jeff Hope · 10-28-2008, 01:22 PM

Carey,

Check these out:

CP Site Saver - Cpanel Backup Software - Free Download

CPanel Backup Software - Automated Back Up Solution For CPanel Users

Runs from your PC, backs up entire site, including MySQL. Can be set to run on a schedule, etc.

Jeff

Carey Archer · 10-31-2008, 10:27 PM

Thanks Jeff,

Great solution, only problem is that we are not based in the US and it will not work without a US phone number and address for registration.

Carey

xanol · 11-01-2008, 07:11 PM

I use sourceforge.net/projects/automysqlbackup

This is on my VPS, and I run it out of cron. But, it should also work on shared hosting.

erbuc · 11-04-2008, 09:08 PM

If your blogs are using self hosted Wordpress, there is a great little utility plug-in I use called WP-DBManager. I have it scheduled to backup my databases at regular intervals and the script emails me the backup file.

You can get it here PHP Programming Portfolio | lesterchan.net

-Nick- · 11-15-2008, 10:23 PM

Well sometimes it depends on the kind of sites.

If it is dynamic and you are updating it on daily basis then daily or weekly backups will do great.

Francis Miller · 11-20-2008, 05:01 PM

I had a similar query on the Warriors Main Internet Marketing Discussion Forum here -

Scripts to backup databases on one's web server

Database Backup Generator - was one of the solutions mentioned.

fthomas137 · 11-20-2008, 06:40 PM

You know, backups really depend on the level you are at. If you are hosting less then 10 sites, then using plugins and the such is reasonable.

IMHO, if you are approaching 10 sites or have many more, DON'T DO THAT!!!! It'll be like hitting yourself with a bat if you ever have to recover!!! I've been there and it was FOUR DAYS OF HELL!

Ahhh, I feel much better! I took a look at the cpanel backup software and I'm going to give it a wack. Backing up cpanel is the way to go! I recommend getting an account with S3 Amazon as the storage center. You will definitely be much better off. Your data will now reside on two different locations.

Again, my 2 cents, but for me, anything automated and complete is the way to fly.

Frank

10-07-2008, 07:08 AM	#1
Carey Archer Warrior Member Join Date: Feb 2006 Location: , , Australia. Posts: 13 Thanks: 0 Thanked 1 Time in 1 Post	MySQL Automatic Backups Hi All, Have all these great sites and blogs and dreaming (nightmare) about my Hosting falling over in the current climate. What is the best way that I can do the automatic backups for MySQL, as the manual process is a full time job? Thanks plenty. Carey

10-14-2008, 03:53 PM	#2
Sean Kelly Advanced Warrior Join Date: Oct 2006 Location: Ireland Posts: 522 Thanks: 5 Thanked 3 Times in 1 Post Contact Info	Re: MySQL Automatic Backups Hi Carey, you can use the mysqldump command to do a database export. Put that command along with your login info and database name and output filename into a .sh file. Then create a cron job that runs every night that calls this script. Make sure the script runs ok first before adding it to a nightly cron. Also remember that every time it runs it will overwrite the previous backup file unless you add a timestamp to the filename. Sean
	http://www.ViralPDF.com - the #1 PDF Rebrander since 2002 http://www.PdfPrinterPro.com - PDF Converter, Create PDF Files. http://www.PdfLocker.com - Lock & Encrypt your PDFs quickly & easily

10-27-2008, 08:56 AM	#3
Carey Archer Warrior Member Join Date: Feb 2006 Location: , , Australia. Posts: 13 Thanks: 0 Thanked 1 Time in 1 Post	Re: MySQL Automatic Backups Thanks Guys, appreciate your help.

10-28-2008, 12:26 AM	#4
Carey Archer Warrior Member Join Date: Feb 2006 Location: , , Australia. Posts: 13 Thanks: 0 Thanked 1 Time in 1 Post	Re: MySQL Automatic Backups What it is that I am after is a recommendation for something that is a gui based tool to backup multiple sites/databases remotely, any suggestions?

10-28-2008, 01:22 PM	#5
Jeff Hope Senior Warrior Member Join Date: Sep 2003 Location: Pottsboro, TX, USA Posts: 1,702 Thanks: 23 Thanked 27 Times in 25 Posts Social Networking	Re: MySQL Automatic Backups Carey, Check these out: CP Site Saver - Cpanel Backup Software - Free Download CPanel Backup Software - Automated Back Up Solution For CPanel Users Runs from your PC, backs up entire site, including MySQL. Can be set to run on a schedule, etc. Jeff

10-31-2008, 10:27 PM	#6
Carey Archer Warrior Member Join Date: Feb 2006 Location: , , Australia. Posts: 13 Thanks: 0 Thanked 1 Time in 1 Post	Re: MySQL Automatic Backups Thanks Jeff, Great solution, only problem is that we are not based in the US and it will not work without a US phone number and address for registration. Carey

11-01-2008, 07:11 PM	#7
xanol Warrior Member Join Date: Oct 2008 Posts: 13 Thanks: 0 Thanked 0 Times in 0 Posts	Re: MySQL Automatic Backups I use sourceforge.net/projects/automysqlbackup This is on my VPS, and I run it out of cron. But, it should also work on shared hosting.

11-04-2008, 09:08 PM	#8
erbuc The Coach Join Date: Dec 2007 Location: Bangkok, Thailand Posts: 27 Thanks: 0 Thanked 0 Times in 0 Posts Social Networking Contact Info	Re: MySQL Automatic Backups If your blogs are using self hosted Wordpress, there is a great little utility plug-in I use called WP-DBManager. I have it scheduled to backup my databases at regular intervals and the script emails me the backup file. You can get it here PHP Programming Portfolio \| lesterchan.net
	Web Services and Tools blog Wellness and Medical travel blog Visit our Online Web University

11-15-2008, 10:23 PM	#9
-Nick- Warrior Member Join Date: Nov 2008 Location: India Posts: 17 Thanks: 0 Thanked 1 Time in 1 Post Social Networking	Re: MySQL Automatic Backups Well sometimes it depends on the kind of sites. If it is dynamic and you are updating it on daily basis then daily or weekly backups will do great.
	Webmaster Blog \| Buy Sell Domains \| Software Downloads \| Web Directory

11-20-2008, 05:01 PM	#10
Francis Miller Active Warrior Join Date: Apr 2007 Location: United Kingdom. Posts: 45 Thanks: 3 Thanked 2 Times in 2 Posts Contact Info	Re: MySQL Automatic Backups I had a similar query on the Warriors Main Internet Marketing Discussion Forum here - Scripts to backup databases on one's web server Database Backup Generator - was one of the solutions mentioned.
	Discover how to use the POWERFUL SKILL OF MIND MAPPING to INCREASE YOUR PRODUCTIVITY and BEAT INFORMATION OVERLOAD. More info here.

11-20-2008, 06:40 PM	#11
fthomas137 Wordpress Warrior Join Date: Jul 2008 Location: , , . Posts: 54 Thanks: 2 Thanked 3 Times in 3 Posts	Re: MySQL Automatic Backups You know, backups really depend on the level you are at. If you are hosting less then 10 sites, then using plugins and the such is reasonable. IMHO, if you are approaching 10 sites or have many more, DON'T DO THAT!!!! It'll be like hitting yourself with a bat if you ever have to recover!!! I've been there and it was FOUR DAYS OF HELL! Ahhh, I feel much better! I took a look at the cpanel backup software and I'm going to give it a wack. Backing up cpanel is the way to go! I recommend getting an account with S3 Amazon as the storage center. You will definitely be much better off. Your data will now reside on two different locations. Again, my 2 cents, but for me, anything automated and complete is the way to fly. Frank
	I'm A Wordpress Freak! Do you have questions about Using Wordpress To Maximize Your Efforts And Minimize Your Frustrations? Click Here!