I'm not sure how many people have experience with Digital Ocean but they're like the new kid on the block for SSD cloud hosting.
Anyways there entire model is to basically be a hosting solution for develops (much like AWS).
I have created a droplet, accessed it via SFTP, and pointed my nameservers in their direction.
However i feel utterly stupid when it comes to migrating a WP site from local to live. I just don't do it enough to ever feel proficient at it.
So here i am wanting to approach the problem in the following order:
1) Backup DB and all files (I have backed up my DB with phpMyAdmin but don't have a solid solution for backing up files)
2) Updated wp-config file to reflect the new URL and i'm not sure much else needs to change if i keep my DB with the same name and password
3) Over right all of the new installed WP files on the server with my local versions
4) Do a find and replace on the DB to update any URL's
I'm having a problem with step 1. I haven't found a good way to backup my files. I am interested in how to gzip my site locally and then ssh into my droplet and un-gzip, update the wp-config file and call it day.
I've been tackling this issue for a week and half, unfortunately i don't have the time to site through one entire day otherwise i would've by now.
Does anyone have any expertise on the matter or a bit of advice for this fool?