Teddy Rogers Posted October 21, 2011 Share 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. Link to comment Share on other sites More sharing options...
Philip_B Posted October 21, 2011 Share 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 Link to comment Share on other sites More sharing options...
Teddy Rogers Posted October 21, 2011 Author Share Posted October 21, 2011 I have a cron job running for backups. Sizes were similar until just recently... Ted. Link to comment Share on other sites More sharing options...
Philip_B Posted October 21, 2011 Share Posted October 21, 2011 Do you use CPanel? Link to comment Share on other sites More sharing options...
Ant__ Posted October 21, 2011 Share 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. Link to comment Share on other sites More sharing options...
Teddy Rogers Posted October 22, 2011 Author Share Posted October 22, 2011 Do you use CPanel? Yes, I use CPanel... Ted. Link to comment Share on other sites More sharing options...
altenerg Posted October 27, 2011 Share Posted October 27, 2011 My backups are nightly straight to Amazon s3 storage. Link to comment Share on other sites More sharing options...
Hunting insects... Posted October 27, 2011 Share Posted October 27, 2011 MySQLDumper Perl script cronjob. Link to comment Share on other sites More sharing options...
DreamPhysix Posted October 28, 2011 Share 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 Link to comment Share on other sites More sharing options...
Christophe Posted October 28, 2011 Share 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 Link to comment Share on other sites More sharing options...
FCB-ROGA Posted October 28, 2011 Share 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? Link to comment Share on other sites More sharing options...
FCB-ROGA Posted October 28, 2011 Share 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? Link to comment Share on other sites More sharing options...
*Salvo* Posted October 28, 2011 Share 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. Link to comment Share on other sites More sharing options...
Rhett Posted October 28, 2011 Share 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. Link to comment Share on other sites More sharing options...
Tiki Tiki Posted October 28, 2011 Share Posted October 28, 2011 Is there a one-step method for performing a complete site backup (files and database(s)) via cPanel? Link to comment Share on other sites More sharing options...
Zhana Posted October 29, 2011 Share 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. Link to comment Share on other sites More sharing options...
Rhett Posted October 29, 2011 Share 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... Link to comment Share on other sites More sharing options...
Zhana Posted October 29, 2011 Share Posted October 29, 2011 Just afraid that it's not safe. Link to comment Share on other sites More sharing options...
Rhett Posted October 29, 2011 Share 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. Link to comment Share on other sites More sharing options...
*Salvo* Posted October 29, 2011 Share 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. Link to comment Share on other sites More sharing options...
Teddy Rogers Posted October 30, 2011 Author Share 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. Link to comment Share on other sites More sharing options...
Christophe Posted October 30, 2011 Share Posted October 30, 2011 Removed password DOH !!! Link to comment Share on other sites More sharing options...
Enkidu Posted October 31, 2011 Share Posted October 31, 2011 I do a full site backup every night and a database backup to RackSpace :) Link to comment Share on other sites More sharing options...
AlexJ Posted October 31, 2011 Share 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 Link to comment Share on other sites More sharing options...
Enkidu Posted October 31, 2011 Share Posted October 31, 2011 rackspace has a script that does that for you. You don't need to worry about anything Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.