4 posts tagged with "Mysql"

In a recent Magento upgrade project for one of our merchants, I encountered a problem with the production database during the setup:upgrade process.

As part of an AI project, I had to export data to train a tool developed for a customer. Instead of writing a script, I decided to use MySQL's built-in functions, which turned out to be a challenging experience but a valuable learning opportunity.

Importing larger database dumps can take a while, especially when foreign key checks are enabled. This slowdown happens because each foreign key reference must be verified by the database server.

While migrating a Magento module to make use of the declarative db schema, I ran into the following MySQL error: MySQL error code 121: Duplicate key on write or update