Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
Teddy Rogers Posted October 21, 2011 Posted October 21, 2011 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.
Philip_B Posted October 21, 2011 Posted October 21, 2011 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
Teddy Rogers Posted October 21, 2011 Author Posted October 21, 2011 I have a cron job running for backups. Sizes were similar until just recently... Ted.
Ant__ Posted October 21, 2011 Posted October 21, 2011 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.
Teddy Rogers Posted October 22, 2011 Author Posted October 22, 2011 Do you use CPanel? Yes, I use CPanel... Ted.
altenerg Posted October 27, 2011 Posted October 27, 2011 My backups are nightly straight to Amazon s3 storage.
DreamPhysix Posted October 28, 2011 Posted October 28, 2011 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
Christophe Posted October 28, 2011 Posted October 28, 2011 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
FCB-ROGA Posted October 28, 2011 Posted October 28, 2011 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?
FCB-ROGA Posted October 28, 2011 Posted October 28, 2011 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?
*Salvo* Posted October 28, 2011 Posted October 28, 2011 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.
Rhett Posted October 28, 2011 Posted October 28, 2011 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.
Tiki Tiki Posted October 28, 2011 Posted October 28, 2011 Is there a one-step method for performing a complete site backup (files and database(s)) via cPanel?
Zhana Posted October 29, 2011 Posted October 29, 2011 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.
Rhett Posted October 29, 2011 Posted October 29, 2011 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...
Rhett Posted October 29, 2011 Posted October 29, 2011 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.
*Salvo* Posted October 29, 2011 Posted October 29, 2011 Yes, how do you backup the entire website, wich script do you use? I've already an account witl AS3, still unused.
Teddy Rogers Posted October 30, 2011 Author Posted October 30, 2011 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.
Enkidu Posted October 31, 2011 Posted October 31, 2011 I do a full site backup every night and a database backup to RackSpace :)
AlexJ Posted October 31, 2011 Posted October 31, 2011 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
Enkidu Posted October 31, 2011 Posted October 31, 2011 rackspace has a script that does that for you. You don't need to worry about anything
Recommended Posts
Archived
This topic is now archived and is closed to further replies.