What's the Easiest Way To Backup Multiple DB's regularly? - GoFuckYourself.com

nexcom28 · 06-06-2013, 10:39 AM

Hello,

Simple question, I have several sites that need the SQL databases backing up on a regular basis and either emailing to me or saving to desktop.
What is the simplest/ best way to do this without manually having to do a backup.

Ideally it wouldn't backup to FTP either (unless it's a different server)

They would need backing up daily or perhaps weekly.

nexcom28 · 06-06-2013, 12:23 PM

Anyone?

I guess some here bother to backup - no?

PornDude · 06-06-2013, 12:24 PM

http://www.phpmybackuppro.net/

baddog · 06-06-2013, 12:28 PM

Does your server have a control panel installed? If so, which one?

alcstrategy · 06-06-2013, 12:32 PM

what db engine? I will assume mysql

i suppose you could write a script to run mysqldump and then mail it or whatever
schedule with cron

Ferus · 06-06-2013, 12:35 PM

SQL or MySQL?

shake · 06-06-2013, 12:35 PM

Quote:

Originally Posted by nexcom28

Anyone?

I guess some here bother to backup - no?

I backup using the command line mySQL interface, but I wouldn't say that's the easiest unless you use the command line all the time anyway...

jwerd · 06-06-2013, 12:38 PM

Here's what I do via cron with mysql for one of my servers:

Code:

20 21 * * * mysqldump -u backup client_hightech | gzip -v9 - > /var/www/clients/nightlies/hightech_nightly.sql.gz
20 21 * * * mysqldump -u backup client_clinicazhen | gzip -v9 - > /var/www/clients/nightlies/clinicazhen_nightly.sql.gz
20 21 * * * mysqldump -u backup client_ics | gzip -v9 - > /var/www/clients/nightlies/ics_nightly.sql.gz

You could add more to it like date/timestamp, if you wanted.

nexcom28 · 06-06-2013, 12:38 PM

I could do with a cron job or something. It's just Cpanel and it's Mysql

Ferus · 06-06-2013, 12:38 PM

IF its MySQL, here is a few tools
http://dev.mysql.com/downloads/tools/utilities/
http://sourceforge.net/projects/phpbackup/
http://www.digitalcoding.com/free-so...t-Windows.html

evil0x · 06-06-2013, 12:42 PM

Write\Google a script to mysqldump and move the file to your dropbox folder.
Set cronjob to w\e...

baddog · 06-06-2013, 12:52 PM

Quote:

Originally Posted by nexcom28

I could do with a cron job or something. It's just Cpanel and it's Mysql

I don't use cPanel but I am relatively confident they have a backup feature. That would probably be the easiest (via cron job)

Klen · 06-06-2013, 12:54 PM

Jwerd method is easiest one.

nexcom28 · 06-06-2013, 12:55 PM

Quote:

Originally Posted by baddog

I don't use cPanel but I am relatively confident they have a backup feature. That would probably be the easiest (via cron job)

I only just started using it this week, I didn't know that but I will look into it.

Thanks for all your answers. Hopefully I will get something sorted soon, these days you can't afford to fuck up.

freecartoonporn · 06-06-2013, 10:37 PM

i use simple shell script for that., it creates dump of db, and then uploads it to remote ftp...

Zoxxa · 06-06-2013, 10:47 PM

I don't think I have used a host in the past 5 years who didn't do daily db backups automatically, have you asked them?

06-06-2013, 10:39 AM	#1
nexcom28 So Fucking Banned Join Date: Jan 2005 Posts: 3,716	What's the Easiest Way To Backup Multiple DB's regularly? Hello, Simple question, I have several sites that need the SQL databases backing up on a regular basis and either emailing to me or saving to desktop. What is the simplest/ best way to do this without manually having to do a backup. Ideally it wouldn't backup to FTP either (unless it's a different server) They would need backing up daily or perhaps weekly.

06-06-2013, 10:37 PM	#15
freecartoonporn Confirmed User Industry Role: Join Date: Jan 2012 Location: NC Posts: 7,683	i use simple shell script for that., it creates dump of db, and then uploads it to remote ftp... __________________ SSD Cloud Server, VPS Server, Simple Cloud Hosting \| DigitalOcean

06-06-2013, 10:47 PM	#16
Zoxxa Confirmed User Industry Role: Join Date: Feb 2011 Location: Ontario, Canada Posts: 1,026	I don't think I have used a host in the past 5 years who didn't do daily db backups automatically, have you asked them? __________________ [email protected] ICQ: 269486444 ZoxEmbedTube - Build unlimited "fake" tubes with this easy 100% unencoded CMS!

06-06-2013, 12:23 PM	#2
nexcom28 So Fucking Banned Join Date: Jan 2005 Posts: 3,716	Anyone? I guess some here bother to backup - no?

06-06-2013, 12:24 PM	#3
PornDude I'm still broke. Industry Role: Join Date: Jul 2008 Location: WildWildWest Posts: 3,084	http://www.phpmybackuppro.net/

06-06-2013, 12:28 PM	#4
baddog So Fucking Banned Industry Role: Join Date: Apr 2001 Location: the beach, SoCal Posts: 107,090	Does your server have a control panel installed? If so, which one?

06-06-2013, 12:32 PM	#5
alcstrategy Confirmed User Industry Role: Join Date: May 2012 Posts: 124	what db engine? I will assume mysql i suppose you could write a script to run mysqldump and then mail it or whatever schedule with cron

06-06-2013, 12:35 PM	#6
Ferus Bye - Left to do stuff Industry Role: Join Date: Feb 2013 Posts: 4,109	SQL or MySQL?

06-06-2013, 12:38 PM	#9
nexcom28 So Fucking Banned Join Date: Jan 2005 Posts: 3,716	I could do with a cron job or something. It's just Cpanel and it's Mysql

06-06-2013, 12:42 PM	#11
evil0x Registered User Industry Role: Join Date: May 2013 Posts: 31	Write\Google a script to mysqldump and move the file to your dropbox folder. Set cronjob to w\e...

06-06-2013, 12:54 PM	#13
Klen Industry Role: Join Date: Aug 2006 Location: Little Vienna Posts: 32,235	Jwerd method is easiest one.