WordPress Development Quick Start Guide

Comparing database backups 

This is one of the easier methods to compare the changes, instead of reviewing executed queries, and identify them. In this method, we take a database backup using phpMyAdmin, execute the user request, and take another database backup. Then, we can use a file compare tool like MELD (http://meldmerge.org/) to check how the database is changed within the request. The limitation of this process is that you need to manually take database backups, and comparing may become time-consuming for larger databases.