Once I got the new domain name bluegalaxy.info, I wanted to move my blog over to the new domain. It was previously hosted on my laptop with a local apache installation at: http://1uslchriston.ad.here.com:8080/blog On the new domain, I wanted to change the landing from “blog” to “codewalk”, and I also don’t need to use port … Continue reading How to move WordPress to a new host
SQL
MySQL: How to run multiple queries in one
Let’s say we have a couple of simple SQL queries, one of which counts the total number of job hours: select sum(Hours) as totalCount from job_details where Job_ID = 42504; and another query that sums the total number of job hours that have been completed: select sum(Hours) as completedCount from job_details where Job_ID = 42504 … Continue reading MySQL: How to run multiple queries in one
Atom: How to run MySQL queries in Atom using a package called Data Atom
In this article, I will demonstrate how to run queries from within Atom using a package called ‘Data Atom’. Step 1: Install Data Atom package Warning: Before attempting to install any packages in Atom, make sure you disable any real-time virus or malware protection programs you have running, such as Malwarebytes. In the Atom Settings … Continue reading Atom: How to run MySQL queries in Atom using a package called Data Atom
MySQL: How to install a test database and confirm the installation
Now that I have installed PHP and MySQL: How to install PHP/MySQL and confirm the installation I wanted to start using MySQL so I searched for a sample database full of data that I could install for testing. I found this “Employee Sample Database” on the dev.mysql.com website: https://dev.mysql.com/doc/employee/en/ The instructions for installation: https://dev.mysql.com/doc/employee/en/employees-installation.html led … Continue reading MySQL: How to install a test database and confirm the installation
WordPress: How to create a Table of Contents page with Python
What I wanted to create was a dynamic Table of Contents page where I could have a listing of all of my published articles, organized by category, and sorted such that categories with the most posts appear first, and the posts under each category are listed from most recent at the top to oldest at … Continue reading WordPress: How to create a Table of Contents page with Python