Databases

Create a Magento Database Dump Without Sensitive Data

When developers set up test environments of production websites, often the database dump used for the development site contains real customer and order data. Usually this data should be removed from development environments for security reasons. You might also fail tests from compliance scanning software. To create a Magento database dump without sensitive data is …

Definer Clauses in Magento Database Exports

In Magento Commerce Edition version 1.13 and above and in Magento 2, there exists definer clauses in Magento database exports when you export the database from the server it resides on.
These definer clauses are used in MySQL triggers and contain the username and host of the server the exist on. They do not pose …

Magento 2 Data Scripts

Magento 2 data scripts are responsible for adding data to the database. In terms of adding a module, the setup scripts will construct the table(s), and then the data scripts will import the data.
Magento 1 used this concept and added any data scripts to the ‘data’ directory in the module’s folder structure.
Within Magento …

Magento 2 Install Setup Scripts

Setup scripts are a key feature in the Magento application. They provide the ability for a developer to add, update or remove data from the database using PHP classes. This guide will focus on how to add Magento 2 install setup scripts.
Let’s add a new module to start with called ‘Siphor_Names’. Start with the …