Question
Question
What is the best way to backup my database on a regular basis?
Hi DO Community!
I’m currently running an auction script on one of my droplets and the weekly backups that DO provides just aren’t frequent enough for bidding data. Some auctions open and close within a few days. Whats the best way to backup the auction data in my database?
I’m running MySQL on a LAMP/Ubuntu stack.
I see the new article on Bacula on the community homepage. Is that a reliable application and is it hard to setup? Is that my best option?
Thanks!
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
×
do you have a location you are backing up to?
I ask because I am going to write a tutorial, and I am trying to get an idea of what people are doing.
right now no. I’m just downloading a db backup manually via phpmyadmin. I would like to setup auto-backups to a remote location. I was thinking of creating a droplet just to store the backups.