What's the Easiest Way To Backup Multiple DB's regularly?

[nexcom28]

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]

Anyone?

I guess some here bother to backup - no?

[PornDude]

http://www.phpmybackuppro.net/

[baddog]

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

[alcstrategy]

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]

SQL or MySQL?

[shake]

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]

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

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]

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

[Ferus]

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]

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

[baddog]

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]

Jwerd method is easiest one.

[nexcom28]

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]

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

[Zoxxa]

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?