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

GoFuckYourself.com - Adult Webmaster Forum (https://gfy.com/index.php)

- Fucking Around & Business Discussion (https://gfy.com/forumdisplay.php?f=26)

- - What's the Easiest Way To Backup Multiple DB's regularly? (https://gfy.com/showthread.php?t=1111715)

nexcom28

06-06-2013 10:39 AM

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.

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 (Post 19657951)

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 (Post 19657977)

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 (Post 19657998)

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?

All times are GMT -7. The time now is 02:44 PM.