Modifying Live Site Without Overwriting Changes

Hey All,

I’m working on a live site by downloading the entire site to my localhost. If I’m working on it for a day, adding/modifying pages etc, and someone on the live site adds a blog post or another developer creates a new page, my local db will obviously not have that new information.

Is there a way to sync only the changes to a particular database table, like wp_posts? I’ve been doing a lot of reading and the closest I’ve gotten to a solution is using WP Migrate DB Pro which allows you to push and pull specific tables, but I don’t think it allows to sync only changes within individual tables.

I’m relatively new at this so much thanks in advance!