The latest from the MySQL community

Numerous fast-growing, cloud-native organizations have selected MySQL HeatWave as their data platform to effectively overcome their growing pains. See how four of them improved performance, scalability, security, and productivity while reducing costs by migrating to MySQL HeatWave.

The MySQL Heatwave Database Service in the Oracle Cloud Infrastructure (OCI) permits users to take automatic, periodic backups of their MySQL database systems (DB Systems). However, if the backup were configured to occur in the middle of the night and the data-altering event occurs during the middle of the day, there could be hours of […]

This blog introduces a new recovery option available for MySQL Database Systems (DB Systems) that, once enabled, permits data recovery to a specific point in time.

MySQL Document Store is a ‘NoSQL’ solution built on top of MySQL. Last month, I gave a talk at THAT Conference about using MySQL Document Store with Node.js. During that talk, one of the attendees asked if it was possible to see the underlying queries executed when we use the CRUD API in Document Store. I did some poking around, […]

MySQL Database Service supports migrations from a live on-premises MySQL 5.7 database to a MySQL DB system on Oracle Cloud Infrastructure (OCI) in almost real-time using replication. Migrating the data in real time helps you achieve minimal downtime and verify that your live production data is all good. If you have not migrated to MySQL Database Service, it is high […]

MySQL Database Service supports easy live migrations from an on-premises MySQL 5.7 database to MySQL Database Service.

MySQL REST Service The MySQL REST Service (MRS) enables fast and secure HTTPS access for your MySQL data. Implemented as a MySQL Router feature, MRS provides the ability to publish RESTful Web Services for interacting with the data stored in MySQL solutions. MySQL Shell for VS Code offers an intuitive way to configure MRS and create RESTful […]

With so much content online today, how do you find the ‘good stuff’ for a certain topic? While I can’t answer for other niches, if you’re interested in MySQL, PHP, and the LAMP stack, well, you already know the answer. Thank you for reading OpenLampTech!

The Newsletter for PHP and MySQL Developers

Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.

In OpenLampTech issue #63, we are looking at great content covering:

• WordPress robots.txt file
• Preventing SQL injections
• 10 books for PHP developers
• Large MySQL tables
• And much much more

I …

Announcing MySQL Shell 8.0.32

While MySQL error codes are useful, understanding what they mean can be difficult. This article looks at common MySQL error codes, non-coded errors, and how to fix them.

MySQL error code format

Each MySQL error includes:

• An error number: A MySQL-specific number corresponding to a particular error.
• An SQLSTATE value: A five-character string that indicates the error condition.
• An error message: A textual description of the error.

MySQL error example

Here’s an example of what a MySQL error code looks like:

ERROR 1146 (42S02): Table 'test.no_such_table' doesn't exist

In the error above: