I never personally tried it, but maybe mysqldbcompare is worth a shot.
Taken from this StackOverflow answer
mysqldbcompare --server1=A --server2=B --changes-for=B --difftype=sql
Should generate SQL statements that will make server B match server A.
If you check the MySQL doc, you can run from same server by only specifying the --server1 option. I would test it on a local server with backups of the current DB and the old DB (before the delete)
Related Posts:
- Postgresql 9.2 pg_dump version mismatch
- What is a better way to backup files than FTP?
- What is the best method to export local WordPress installation and import to live server?
- How to Add Back Buttons to Web Pages [closed]
- How to backup and restore configurations
- How to perform WordPress backups using wp-cli?
- WordPress Admin Interface not styled properly
- Is it possible to create a WordPress backup by simply copying it?
- Updating to new 3.0.5
- Managing Backups: Space Issues [closed]
- WordPress staging environment that syncs everything except posts?
- Which Blog Client for Windows/Linux has the best support for backing/restoring your posts?
- WordPress manual restore not completely successful
- Backup custom table
- Backup localhost (wamp) database (phpmyadmin) from harddrive files on windows? For WordPress?
- Restored my site using a backup. Seems to be OK but the posts are empty?
- Backing up WordPress before an update, what’s the easiest way to do this?
- Restoring backup of wordpress website on LAMP
- Recover wordpress by replace file manually
- Can I Restore My Website Pages Without mySQL Database?
- How can I make revisions more extensive?
- what to backup (for partial restore)??
- Backing up an old version of WP before upgrading
- How to restore all items from trash
- BackupBuddy, for backups, backups in general etc, any good?
- How do you “test-restore” a backup?
- How to fully backup a WordPress site?
- How do I passively back-up my WordPress websites on a frequent basis? [closed]
- How to setup a wordpress backup in localhost?
- How to completely save my wordpress data?
- Can I delete .git folder in a completed WP project?
- Auomated crash recovery?
- back up fully Customized WordPress theme [closed]
- Restoring from a old local copy of xampp folder where the project was stored
- WP was redirecting to install.php, I installed again and replaced old files with new one but lost all data
- Can I roll back WP Install but keep my newer database?
- How to Backup and Transfer Everything to Another WordPress Site?
- Duplicated WordPress Site STILL Linked to Old Site
- Backup wordpress installation on shared hosting
- Using database in new instalation
- How to copy a WP website to new domain name?
- Why is RAID not a backup?
- GIT as a backup tool
- How to backup 20+TB of data?
- How to keep the full path with rsync?
- How to backup my plugin database [closed]
- Adb backup does not work
- input file appears to be a text format dump. Please use psql
- How to extract or unpack an .ab file (Android Backup file)
- What’s the simplest way to backup my WordPress database?
- Plugin for automatic database backup? [closed]
- What is the best WordPress plugin for Amazon s3 backups? [closed]
- Does WordPress Import/Export tool actually exports media (images) as well?
- How to clone and locally run a network for testing
- Recover from failed multisite conversion
- What is the best practice to get a site from local to online?
- Why isn’t my imported database showing up? install.php pops up and adds new tables to the database
- Why are no posts showing despite my apparently correct DB restoration?
- What happens if I overwrite the current wp_options table with a backup from a week ago?
- Edit page’s “Restore the backup” link does nothing
- The safest way to automate WordPress backups
- Are there any scripts, classes, and/or functions built-in to WP for a plugin to export/import its saved data from wp_options?
- What can be wrong when automated backups stop being sent to email?
- Why does importing copies of the database dump and the document root make WordPress data inconsistent?
- Store partial database to an archive database time to time
- Issues copying site into local machine
- Where is phpMyAdmin inside WordPress?
- FTP Widget Location
- Update a buggy installation
- UpdraftPlus installed malware – scared to download or update plugins now! [closed]
- Do I need a backup plugin if I’m already backing up via cPanel?
- How to remove symlink from folder
- Backing up WordPress database and files
- For a complete backup, is it enough to copy htdocs and export database?
- Automatic WordPress Backup Plugin works, but says it’s not
- Is it possible to restore a deleted WordPress plugin I deleted from WordPress admin menu?
- Migrate site from local to local via a backup
- Can you Recover a WordPress User from a Backup
- wp-config.php not affecting my site
- SQL database import #1046 error
- Recovered WordPress installation (on localhost) links broken and images not showing
- Is it safe to update an old site after backing it up and activating a child theme?
- Advice On How to Backup WordPress
- How to transfer all posts, pages and media
- How can I export data without using any import/export plugin
- blank page after update my theme
- Moving WordPress site from local PC to local Mac
- Backup Restore turns carriage returns to literal strings
- I have a WordPress 4.6 database dump – how do I use it in a new install?
- Find/ascertain latest wordpress db from multiple database copies
- Best way to move a site to a subfolder for testing purposes?
- Inactive Plugin Files
- Best method to upgrade WordPress and Plugins
- Auto Update fail time my external folder deleted
- How to replace a wordpress installation in root directory with another in a subdirectory?
- Post restoration
- Backup Buddy Questions
- how to restore wordpress backup(.rar) manually?
- How to Move a production WordPress site to local environment [closed]
- Restore posts, but only posts that exist in my database backup