The Basics of Terraform IAC

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

Resetting WordPress Admin User via HeidiSQL

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

Installing WP-CLI

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

How to Export MySql Database with PhpMyAdmin

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

WordPress plugin database export

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

How to Backup MySQL Database

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

Migrating your Worpress MySQL Database to AWS Aurora

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