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 … Read more
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 … Read more
At some point in your WordPress travels you will come across a problem with plugins and /or theme conflicts. You may experience such behavior as white screens, failing JavaScript or php or may seem visible error in the website on the front-end or in the admin dashboard. These conflicts (bugs) can be extremely frustrating to … Read more
An integrated development environment (IDE) is a software application that makes writing and editing and deploying code easier. Use this: https://atom.io/ Why? Because you could waste your life searching google or you can take my word for it and stop procrastinating. I like it because it’s free and does everything else that most of the … Read more
Lesson 1 – GIT GitLab and Source Control Source control is important because it allows you to track changes to your code and rollback if you have made a mistake, it also allows to more easily colaborate with multiple developers working on the same project. a) Install GIT https://www.atlassian.com/git/tutorials/install-git b) Sign up for GitLab – … Read more
Here’s a link to my Trello site launch checklist https://trello.com/b/Bv0QuK4o/wordpress-devops-site-launch-checklist
Prerequisites: Setup your EC2 Instance with Ubuntu Installed WordPress Site Installed CertBot Configured Ngnix Virtual Host for non SSL This guide assumes that you have already setup a WordPress site on your EC2 Ubuntu instance with Nginx with no SSL enabled. SSH into your Ubuntu EC2 and run the following commands: sudo certbot –nginx -d … Read more
Register for an AWS Account Launch EC2 Instance with Ubuntu LTS 18.04 Save your PEM key in a safe place Install Putty Convert PEM Key to PPK using PuttyGen or other method SSH to your new EC2 This video shows you the bare minimum to get an EC2 Instance setup, if you are to use … Read more