Whats your Backup Solution?
- Thread starter seojoseph
- Start date
Same as eva.2000 suggested to me.
But I haven't try it as I don't know where to start
- Backup by host (daily)
- 2 additional harddisks (Raid 1) with backkuppc http://backuppc.sourceforge.net/info.html
- some local backups
- 2 additional harddisks (Raid 1) with backkuppc http://backuppc.sourceforge.net/info.html
- some local backups
TPerry
Well-known member
If you are referring to the VPS provider.... hopefully you won't have the problems I had with them when I cancelled service with them (since I no longer needed it). I cancelled about 2 months ago and still get hit on my card with a charge from them - and then have to jump through hoops to contact them, contact the bank (since I use a card that I keep a VERY low balance on until I transfer money into to make payments - it's a separate checking account). Last ticket I entered to them I notified them that it was going to start costing them $75 per hour 2 hour minimum if they processed any more charges. We'll see on the 15th when it normally hit.
Moshe1010
Well-known member
I'm paying with PayPal. I never pay with credit/debit cards on unknown companies/websites, especially hosting. If they don't accept PayPal (rare), I generate virtual credit card numbers through citi/discover credit cards, and pay with them.
seojoseph
Member
Bravo for that. I never heard of those.
Thanks.Our new host; http://www.ramnode.com doesn't do backups very frequently. I wish they did. I might actually just try what @Luke Foreman suggested.
Luke F
Well-known member
Bravo for that. I never heard of those.
rdiff-backup is pretty amazing, I've got daily backups going back months stored in less than 2x the size of a single backup, and with rdiffweb you can restore any revision of any file/folder in a dropbox-style web interface
The only things it lacks are encryption (sure you can use something like encfs, but it has to be unlocked while backing up) and compression
seojoseph
Member
How fast is the restore from a rdiffweb? its pretty quick?
Last edited:
seojoseph
Member
http://www.linuxjournal.com/article/10701 - sweet. Kind of like subversion. I love it!
x4rl
Well-known member
Was it easy to setup Dark?
Adam Howard
Well-known member
ssh is your friend.
database:
mysqldump --opt -uUSERNAME -pPASSWORD DBNAME > /PATH/TO/backup-name-date.sql
files:
tar -zcvf Back-name-date.tar.gz /home/USER/public_html
Download all the above.
Of course if moving, I like to take 1 extra step and do at least a manual file download as well (on the safe side).
And it should go without saying to never leave your backups on the server. Can't tell you how many people claim to have made a backup, yet never downloaded it and left it on the server.
And for security, never have a backup inside /public_html/
database:
mysqldump --opt -uUSERNAME -pPASSWORD DBNAME > /PATH/TO/backup-name-date.sql
files:
tar -zcvf Back-name-date.tar.gz /home/USER/public_html
Download all the above.
Of course if moving, I like to take 1 extra step and do at least a manual file download as well (on the safe side).
And it should go without saying to never leave your backups on the server. Can't tell you how many people claim to have made a backup, yet never downloaded it and left it on the server.
And for security, never have a backup inside /public_html/
Alteran Ancient
Well-known member
I force myself to do a backup every Sunday night. It's usually quiet around then, so I can shut my forum for 10 minutes and do an SQL dump.
If there was an idiot-proof means to dump a backup on schedule to an off-server location, that would be even better. Give me a month or so - my new professional job is going to involve Backup and Monitoring systems, so I may learn a thing or two.
If there was an idiot-proof means to dump a backup on schedule to an off-server location, that would be even better. Give me a month or so - my new professional job is going to involve Backup and Monitoring systems, so I may learn a thing or two.
seojoseph
Member
reading the documentation right now - rdiff-backup + rdiffweb seems like a solid solution. https://clientarea.ramnode.com/cart.php?gid=11 and $20 a year - so if he has months of backups for *2 of a normal tar.gz 50GB is way more then enough for me at least. Getting the flow down with the database backup still needs to happen but this direction seems like the right one for me.
SneakyDave
Well-known member
That mysqldump command doesn't even include the host name...and for those who don't know - Adam is pretty awesome.
The better, and much preferred mysql dump command from a script would look like:
Code:
mysqldump -q -f -Q -e -h[HOSTNAME] -u[USERNAME] -p[DBPASSWORD] [DBNAME] | gzip > [BACKUP_PATH]/[DBNAME].1.sql.gz
Last edited:
