I have created a web app locally in WAMP with PHP and a MySQL database. I am about to launch a demo online on a Linode server.
My question is once I have got it live on LINODE and I want to add a new Mysql table locally on WAMP how do i push the MYSQL changes to the live version online. I am not sure what this is called and how to do it. if anyone can share ideas/videos that would be awesome
I would suggest using a MySQL Replica, in which the replicated database will only be read from.
That or you can create some type of CI/CD pipeline which will run the same queries on your local as the remote, but that's a bit more complex.