Skip to content

Instantly share code, notes, and snippets.

View fwolfst's full-sized avatar
🐢
:

Felix Wolfsteller fwolfst

🐢
:
View GitHub Profile
@fwolfst
fwolfst / Magento 1.x Orphaned Records Cleanup.md
Last active April 16, 2018 11:50 — forked from dfelton/Magento 1.x Orphaned Records Cleanup.md
Deletes orphaned records from a Magento 1.x database.

Purpose

The purpose of this SQL script is to clean up a Magento 1.x database by deleting orphaned records from database tables which cause foreign key contraint failures. This happens when at some point in time records where deleted from the database while FOREIGN_KEY_CHECKS = 0 and the person performing the delete operations failed to delete all related records pertaining to related tables of the primary table.

This script can be helpful when encountering foreign key constraint failures using the Data Migration Tool to migrate your