Notes

Databases

  • Allowing remote access to MySQL
  • Automated MySQL Backups to Amazon S3 with AutoMySQLBackups
  • Backing up and Restoring Databases
  • Common MySQL Errors
  • Connect to MySQL installed by MAMP via Command Line (Terminal)
  • 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
  • Notes on Moving from MySQL to MariaDB and Replication
  • Notes on Moving Large Databases
  • 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
  • Tips for Querying a MySQL Database
  • Update WordPress posts for SSL https
    • Browse all topics