Terraform IAC is a cloud-based program that allows you to create, edit, and delete infrastructure as code. Terraform enables developers to write declarative configuration files in HCL (Hashicorp Configuration Language). These declarative configurations can be applied by Terraform using the terraform apply command which will build or modify resources automatically based on the configuration. This… Continue reading The Basics of Terraform IAC
Download and install HeidiSQL (should also work with any of your favorite MySQL clients) Connect to your database and use these queries in the query panel select * from wp_users UPDATE wp_users SET user_pass=MD5(‘123456′) WHERE user_login=’me’; Don’t have an admin user account do this instead to create a new one: INSERT INTO wp_users (ID, user_login,… Continue reading Resetting WordPress Admin User via HeidiSQL
So you have made a mistake like eating last nights left of curry and now you are regretting it, unfortunately you can’t take that one back but thankfully with Git you can get back to a state of sanity, ready? Here we go! Undo Your Last Commit $ git reset –soft HEAD~1 git reset will… Continue reading How can I undo the last Git commit?
Shortcut to install: copy the line below and paste it into your terminal and you should be ready to go. curl -O https://raw.githubusercontent.com/wp-cli/builds/gh-pages/phar/wp-cli.phar && chmod +x wp-cli.phar && sudo mv wp-cli.phar /usr/local/bin/wp See more videos on WP-CLI How to Export WordPress Database with WP-CLI
Open PhpMyAdmin control panel (you may need to login with a username and password) Select the database that you want to export Click on Export Choose Quick or Custom then press the Go Button to download the file to your computer Feel free to leave a comment or question
Go to the Add Plugin menu and Search for Database backup Choose a plugin of your choice, in this video I am using UpdraftPlus Install and Activate the Plugin Open the plugin settings Backup the database only Download the file to your computer Check the file
There are many ways to backup a MySql database such as: WordPress plugin database export PhpMyAdmin (Most common for shared hosting) Heidi SQL MySqlDump (Most versatile) WP-CLI database export (Recommended for WordPress) From all of these methods my personal favorite method is to use WP-CLI, however this method may not be available to you if… Continue reading How to Backup MySQL Database
Amazon Aurora is an enterprise-class, fully managed database service available at 1/10th the cost of commercial databases. In this tutorial I am going to show you how to migrate your existing MySql WordPress database to Aurora. Benefits include: High performance and scalability: Get 5x the throughput of MySQL, 3x the throughput of PostgreSQL, 64TB of… Continue reading Migrating your Worpress MySQL Database to AWS Aurora