How to Reset the Primary Key Sequence ID in PostgreSQL
I run into an issue today with PostgreSQL. I had manually entered a row into a table and it caused the primary […]
Category: SQL
Fixing MySQL Error 1153 – Got a packet bigger than ‘max_allowed_packet’ bytes
To fix, “MySQL Error 1153 – Got a packet bigger than ‘max_allowed_packet’ bytes” on Ubuntu edit your /etc/mysql/mysql.conf.d/mysqld.cnf. Once you have opened […]
How to Display and Debug All Database Queries Made by WordPress
When working with WordPress you will eventually have the question, “How do I display all database queries made by WordPress?” In your […]
Disable MySQL Strict Mode and NO_ZERO_DATE Errors in Laravel Homestead
If you are using MySQL 8 or 5.7, on Laravel Forge, for example, use the command sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf. The options file […]
Import and Export MySQL and PostgreSQL
There are many ways to export and import data from a database. You can use a Mac client like Sequal Pro for […]
Raw PHP and MySQL Eager Loading
Working with complicated and joined data sets can be tricky for MySQL database performance. For example, What if you need to load […]
Character Encoding UTF-8: PHP, HTML,and MySQL
Note: Sequel Pro has not had a stable update in some time and I no longer use it. I love Sequel Pro. […]
Enabling Performance Monitoring for MariaDB and MySQL
Enabling performance monitoring for MariaDB and MySQL works the same way. Performance monitoring for databases is beneficial when you have records in […]