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 […]
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. […]
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 […]
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 — […]
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 […]