Categories
gcp

Google Cloud SQL database exports using Cloud Scheduler

This is going to be a quick and to the point blog. As many of you know (if you’re here at this point, I know you know), Google Cloud SQL backups are directly linked to the instance itself. WHAT!? That means if the instance is deleted, so are your backups. As a DevOps engineer, this […]

Categories
Kubernetes

Kubernetes: WordPress on GKE using Cloud SQL

Create MySQL database Click CREATE INSTANCE. Choose MySQL. Choose an Instance ID and Root password. Click Create. Click on the USERS tab. Click Create user account. Insert wordpress as the User name and create a Password. Click CREATE. Feel free to use openssl to create a password. openssl rand -base64 32ux9ftpLM6YSB8gnCB+LOomCqp+gPlnk63JJEzCEp1Uo= Click the DATABASES tab. […]

Categories
Wordpress

WordPress 5 Minute Install

This setup assumes that you are running a web server and mysql on the same server. Step 1 cd into your root directory. cd /your/root/directory Step 2 Download and unzip. wget https://wordpress.org/latest.tar.gz && tar -xzvf latest.tar.gz && rm -rf latest.tar.gz && cd wordpress && mv * .. && cd .. && rm -rf wordpress Step […]

Categories
Code Linux MAC UNIX Wordpress

WordPress Backup on CentOS

Now that I’ve moved my website over to CentOS, I’ll be showing you how I do backups. My Setup VirtualBox – CentOS web server running WordPress iMac – connected Drobo Goal Run daily mysql backups Run weekly website backups Only keep the latest two backups Run daily rsync’s to my Drobo from my iMac CentOS — […]

Categories
Linux MAC UNIX Wordpress

Backup your WordPress Website to Dropbox on a Mac

We learned how to Backup & Restore a MySQL database HERE. We learned how to tar a directory HERE. Now lets combine this knowledge and backup our WordPress Website directly to Dropbox. IMPORTANT: Keep in mind that I am running my website on my MAC (not a Linux distro). You will need the following information: Web […]