I am using Laravel Framework 6.16.0 and PHP 7.4.1. I am using git-ftp to upload my changed files to my shared host.
However, as I creating new tables, I would like to upload the changed tables from my development environment to my server's production database automatically.
Currently, I am deleting the production database and update the production database with a new sql file from my development environment.
Is there a automatic process to ALTER tables and update the currently run production database?
What's your process to update the production database? (also if there is already some real user-data inside?