Restore MySQL database partially – Database Administrators Stack Exchange


I am using WordPress to run my website, along with the traditional MySQL Databases. Whilst seeking to speed up my website, I decided to clear some of the old and unused tables with WP-Optimizer. Sadly, it seems that I have deleted something I shouldn’t by mistake, since it seems I have partially broken Elementor Plugin.

I luckily have a database backup, but it is a few days old and, given there are a lot of modifications done on a single day, I do not wish to simply import that backup; what I’d like, is to compare my website’s database with my backup and restore the missing tables only, after thorough examination of their content.

I am no SQL expert at all and looking for guidance.