Solved How do you backup your VPS servers?
-
@IRJ said:
@scottalanmiller said:
@IRJ said:
So I guess a better question would be what are my options? What are the pros and cons for each option?
Let's start with your workload. What are you running and what are your recovery needs?
I am running a Wordpress site. My recovery needs would be a week on the server and daily on Wordpress\database.
Okay, this should be pretty easy then. WordPress has built in backup tools available. Use those to automate getting a database backup to the filesystem. No need to know MySQL or MariaDB at all.
Now the hard part... to where to send the backup...
-
Do you have another server or any sort or a desktop or something? Where would you want to store the database backup? I would typically start by looking to Rsync the files daily off to another UNIX server or NAS device somewhere.
-
But you could script stuff to send to S3 or other cloud service, to email the files, etc. Tons of options.
-
@scottalanmiller said:
@IRJ said:
@scottalanmiller said:
@IRJ said:
So I guess a better question would be what are my options? What are the pros and cons for each option?
Let's start with your workload. What are you running and what are your recovery needs?
I am running a Wordpress site. My recovery needs would be a week on the server and daily on Wordpress\database.
Okay, this should be pretty easy then. WordPress has built in backup tools available. Use those to automate getting a database backup to the filesystem. No need to know MySQL or MariaDB at all.
Now the hard part... to where to send the backup...
Updraft Plus is a cool Wordpress plugin that backs up the entire site to other cloud hosted file storage. I have mine being backed up to Google Drive.
-
@coliver said:
@scottalanmiller said:
@IRJ said:
@scottalanmiller said:
@IRJ said:
So I guess a better question would be what are my options? What are the pros and cons for each option?
Let's start with your workload. What are you running and what are your recovery needs?
I am running a Wordpress site. My recovery needs would be a week on the server and daily on Wordpress\database.
Okay, this should be pretty easy then. WordPress has built in backup tools available. Use those to automate getting a database backup to the filesystem. No need to know MySQL or MariaDB at all.
Now the hard part... to where to send the backup...
Updraft Plus is a cool Wordpress plugin that backs up the entire site to other cloud hosted file storage. I have mine being backed up to Google Drive.
I just set that plugin up. Thanks for mentioning it.
-
@coliver said:
@scottalanmiller said:
@IRJ said:
@scottalanmiller said:
@IRJ said:
So I guess a better question would be what are my options? What are the pros and cons for each option?
Let's start with your workload. What are you running and what are your recovery needs?
I am running a Wordpress site. My recovery needs would be a week on the server and daily on Wordpress\database.
Okay, this should be pretty easy then. WordPress has built in backup tools available. Use those to automate getting a database backup to the filesystem. No need to know MySQL or MariaDB at all.
Now the hard part... to where to send the backup...
Updraft Plus is a cool Wordpress plugin that backs up the entire site to other cloud hosted file storage. I have mine being backed up to Google Drive.
Yeah I am already doing that. I use it for a couple sites.
-
@IRJ said:
@coliver said:
@scottalanmiller said:
@IRJ said:
@scottalanmiller said:
@IRJ said:
So I guess a better question would be what are my options? What are the pros and cons for each option?
Let's start with your workload. What are you running and what are your recovery needs?
I am running a Wordpress site. My recovery needs would be a week on the server and daily on Wordpress\database.
Okay, this should be pretty easy then. WordPress has built in backup tools available. Use those to automate getting a database backup to the filesystem. No need to know MySQL or MariaDB at all.
Now the hard part... to where to send the backup...
Updraft Plus is a cool Wordpress plugin that backs up the entire site to other cloud hosted file storage. I have mine being backed up to Google Drive.
Yeah I am already doing that. I use it for a couple sites.
Then what more were you seeking?
-
@scottalanmiller said:
@IRJ said:
@coliver said:
@scottalanmiller said:
@IRJ said:
@scottalanmiller said:
@IRJ said:
So I guess a better question would be what are my options? What are the pros and cons for each option?
Let's start with your workload. What are you running and what are your recovery needs?
I am running a Wordpress site. My recovery needs would be a week on the server and daily on Wordpress\database.
Okay, this should be pretty easy then. WordPress has built in backup tools available. Use those to automate getting a database backup to the filesystem. No need to know MySQL or MariaDB at all.
Now the hard part... to where to send the backup...
Updraft Plus is a cool Wordpress plugin that backs up the entire site to other cloud hosted file storage. I have mine being backed up to Google Drive.
Yeah I am already doing that. I use it for a couple sites.
Then what more were you seeking?
Our opinions. He stated that in the OP.
-
Has this been sufficiently answered at this point? Or should we provide more info?