I am writing a website on my computer and then uploading changes to the website to the sever periodically. I'm using phpmyadmin and mysql on both the server and my local test machine.
How would just update the structure of the table on the server without having to loose data? My test computer i don't care about the data before i work on it i get database but as im working on it all i change is just the structure. so how would i just change the table's structure?