Notes

Databases

  • Allowing remote access to MySQL
  • Automated MySQL Backups to Amazon S3 with AutoMySQLBackups
  • Backing up and Restoring Databases
  • Common MySQL Errors
  • Conditional Statements in SQL with CASE
  • Connect to MySQL installed by MAMP via Command Line (Terminal)
  • Database Foundations
  • Delete ALL Unapproved comments in WordPress
  • Enable logs (general, error, slow query) for Amazon RDS databases (MySQL, MariaDB)
  • Find out MySQL Database sizes
  • Finding slow MySQL queries
  • Getting started with Firebase Hosting
  • Getting started with PostgreSQL on Ubuntu
  • How to add a WordPress Admin user via PhpMyAdmin
  • Install MongoDB on MacOS
  • Intermediate SQL
  • Joining Relational Data between Tables in SQL
  • Making a MySQL database connection with PHP
  • Manipulating Schema with SQL
  • MongoDB Basics
  • Notes on Moving from MySQL to MariaDB and Replication
  • Notes on Moving Large Databases
  • Notes on SQL
  • OpenCart: Bulk Update Customer Group via phpmyadmin
  • OpenCart: Bulk update prices of Products
  • OpenCart: Delete Multi-Store and Move Everything to the Default Store
  • Referencing data from multiple tables using JOINs
  • Reset MySQL root password on Linux
  • Search for characters in SQL with LIKE and CONTAIN
  • Secure MySQL installation non-interactively with a bash script
  • SQL basics
  • SQLite Basics
  • Tips for Querying a MySQL Database
  • Update WordPress posts for SSL https
  • Using PHP with MySQL
    • Browse all topics