Thread

Im looking for a solution to backup a large database on a regular basis automatically. Ive already figured that ill probably have to use cron-jobs and i have an S3 service set up but what im worried about is that the databases’ im looking to backup are very large. by very large i mean hundreds of Megs (soon to be gigs).

is this the right way about backing up these? i have full root access to the server so memory limit is not a problem as i can set it to pretty much anything i need.

if anyone can shed some light on this i would be very grateful. in the future im sure we will have on site tape-drive backups or some other solution like that but since we are in development stage we need a solution that can safe keep our data.

thanks 😊

I personally would just recomend an export every x often at the least trafficky time of the day. Their is nothing wrong with remote backups, especially when it comes to automating them.

One thing I can highly recomend while doing these backups is that you only move changed data. Their is no sense copying over the same data.

Only move records that have changed, updated, or been removed. It will cut a lot of the backup time out.