I am curious to know how other people backup their databases on a regular basis? Currently I use a cron job (because I am too lazy to do it manually), it backs up the database and then gzip's it. However I have been having a problem over the past couple of weeks with very erratic and incomplete backup sizes. The database is just under 400MB in size and I am running my board on a dedicated server. Looking at server stats the memory and cpu averages seem to be fine, never a problem, so I don't quite understand why a backup should be say around 67MB then the next backup is 41, 8, 11, 30, etc. Any ideas?

Ted.

backups should in most cases be similar sizes unless lots of data is added/ deleted in the interim. Do you use CPanel? I just backup from there

I have a cron job running for backups. Sizes were similar until just recently...

Ted.

Do you use CPanel?

have a cronjob setup to run a shellscript in the small hours.
1.runs a sqldump of the DB splitting the posts table into a separate script,
2. tars it up with a datestamped filename
3. removes the sql scripts after
4. ftp's it offsite to a storage server.

nothing fancy but was easy to create and works well.

Do you use CPanel?

Yes, I use CPanel...

Ted.

My backups are nightly straight to Amazon s3 storage.

MySQLDumper Perl script cronjob.

I have a crontab:

0 3 * * * cd /root/ && sh backup.sh

that does the following:

#!/bin/bash

TIME=$(date +"%m-%d-%y")

cd /root/backup/

mysqldump USER1_DB1 > USER1_DB1_$TIME.sql

gzip *.sql

scp -l 85000 -P PORT * root@BACKUP.SERVER:/root/backup/

rm -rf /root/backup/*

exit

I use a free open source app on OS X called Sequel Pro http://www.sequelpro.com/
It does everything one needs for mysql management.
I back up once a week and every time before making changes manually to the database

Otherwise my hosts backs up every night

have a cronjob setup to run a shellscript in the small hours.

1.runs a sqldump of the DB splitting the posts table into a separate script,

2. tars it up with a datestamped filename

3. removes the sql scripts after

4. ftp's it offsite to a storage server.

nothing fancy but was easy to create and works well.

I have no experience setting up cronjobs. Any chance you can PM me some details on this so I can get my DB backing up daily to my Amazon s3 bucket?

My backups are nightly straight to Amazon s3 storage.

via cronjobs as well?

If so, any chance you can PM me some details setting up a cronjob via cPanel?

AutoMySQLBackup.
This is a shell script for who has a server with lots of db to backup every day, or more.
I use to. In a total different directory, of course.

I run direct admin on all my servers... for busy sites I run it twice a day...all through the CP... one stays on the server, one goes to a NAS at the data center. These are complete site backups... for non busy sites I run it once a week or day depending on the site and store both locally and to a NAS.

Is there a one-step method for performing a complete site backup (files and database(s)) via cPanel?

I run direct admin on all my servers... for busy sites I run it twice a day...all through the CP... one stays on the server, one goes to a NAS at the data center. These are complete site backups... for non busy sites I run it once a week or day depending on the site and store both locally and to a NAS.

Same here full backups using DA.

My backups are nightly straight to Amazon s3 storage.

Can you please post some guide on how to setup AS3?


Thank you.

Same here full backups using DA.

Can you please post some guide on how to setup AS3?

Thank you.

If your using DA, just use the FTP method... and enter your cloud ftp info...

Just afraid that it's not safe.

If your worried about security of transferring the files.. then I would recommend an internal NAS at your datacenter. Most offer some sort of internal backup system, that's not exposed to the net.

Yes, how do you backup the entire website, wich script do you use? I've already an account witl AS3, still unused.

This is the syntax I use for the cron job on my server - hopefully it is useful to others...

cd /home/george/www/backups/ ; mysqldump --opt --user=uxxxxxxxx--password=xxxxxxxx d42423582 | gzip -v9 - > d42423582-`/bin/date +%y%m%d.%H%M%S`.sql.gz

Ted.

Removed password

DOH !!!

I do a full site backup every night and a database backup to RackSpace :)

I do a full site backup every night and a database backup to RackSpace :smile:

How do upload it on other website? Does anyone got any crob job for dumping DB every night and uploading on some other FTP every night? Dumping should add date suffix at the end.

Thanks

rackspace has a script that does that for you. You don't need to worry about anything