Jump to content

How do you backup your database - regularly?


Recommended Posts

Posted

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




I don't host with them and I have no plans to do so. I have my 3 machines with space of 1TB on each and i m only using less then 50GB.

What i am doing right now is set up cron job to dump DB every night and every week I download it manually which is taking long time since DB has reached 800Mb. Server to server will be much faster and i don't have incremental back ups so i need to fix that too.
Posted

I don't host with them and I have no plans to do so. I have my 3 machines with space of 1TB on each and i m only using less then 50GB.



What i am doing right now is set up cron job to dump DB every night and every week I download it manually which is taking long time since DB has reached 800Mb. Server to server will be much faster and i don't have incremental back ups so i need to fix that too.




you don't need to be hosted with them. All you need is to upload their script to your server and then install the server management software on your desktop computer. After that you can control what, where, when and how often to backup from your desktop :)
Posted

you don't need to be hosted with them. All you need is to upload their script to your server and then install the server management software on your desktop computer. After that you can control what, where, when and how often to backup from your desktop :smile:




oops! My bad I understood it wrong. Thanks! Will try it tonight
  • 6 months later...
Posted

bqbackup.com and webbycart.com for remote ftp/sftp/rsync backup services + my own custom bash shell scripts for file and database backup

Posted

I use AutoMysqlBackup which is an open source project to backup my databases daily,weekly and monthly and then use rsync to sync the backups to my home NAS.

Posted

I use SQLyog Ultimate, with scheduled backup via cron and/or scheduled tasks (depending on what OS I am using at the time).

Have it set to backup every 3 hours, where I get a copy on my NAS and I also have it go to the cloud. I do something similar with WHM backup, to remote servers, all accounts, all DB etc.

Posted

I have a custom script run via cron to backup to amazon s3 every day. It saves multiple copies from daily~monthly for the database.
For the files, I'm running a custom CDN which naturally makes like quadruple clones of everything at near real time with write only, no deletes except updates via mix of rsync and nginx proxy. So I find little need make additional backups. Besides, it's the db that's important. ^^

Posted

Yeah S3 prices have come down a bit, interested to know how much you guys are paying for it.

i.e. with webbycart.com i'm paying US$8.3/month for 100GB backup space and get full ssh/ftp/sftp/scp/rsync/web gui access to backups

Posted

Mine is quite simple.

I use Parallels Plesk Panel and simply have a daily server backup scheduled that transfers it via ftp to a secure host.

Posted

what im afraid of is BW/space usage....


p4guru, you get that price and how much rasources do you use daily or monthly




~60+ GB/month in backups from 7 servers.. i wrote a clean up script which retains 10-14 days worth of backups, anything older than 10-14 days gets automatically removed via cron job setup via ssh on webbycart's backup server :smile:
Posted

sorry for the OT how much do you pay for s3?



I actually pay $0. lol!!

s3 has a promo (this promo has been avl for a long long time now) where you get 1 full year of free s3 if you use less than 5GB of data for storage. My database alone with number of iterations I have, compressed is a little shy of 5GB.
Bandwidth usage is always just backup file being uploaded and incoming bandwidth is always free for any amount. So, 0 there again.
I've downloaded a few times, but my download costs never managed to reach 1 cent. So, 0 there again.

So, I haven't paid anything for it. I use their other services though, so I pay them something, just not for s3. If you use more than 5GB, you'd be only charged for above 5GB.

For small things, s3 is definitely the most affordable backup method. But their prices increase nearly arithmetically. So, if it's large, it becomes no longer cost efficient.

If you're looking for very affordable and large backup source, there's Kimsufi. 15 euro for a 1TB disk dedi server. Cheapest storage space avl out there.

Archived

This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...