This is an automated archive.

The original was posted on /r/mysql by /u/itchy_niche on 2023-08-03 08:54:06+00:00.

My situation is I have small web app on a VPS that relies heavily on a database. On my laptop I have a copy of the database where I make changes as needed, and then basically wipe out the online database and restore using the local copy. This seems to be not very intuitive, introduces downtime, and it would be much easier to UPDATE the database instead of wipe and INSERT every time. It is necessary for me to work on a local copy because my program makes mistakes importing data that need clearing up, and I don’t want to push these mistakes to the production until everything is good.

Thank you for the advice, open to any solution here.