Essentially what I'm trying to do is sync a production server with a sandbox server, but only the table structures and stored procedures. The procedures aren't any problem since they can be overriden, but the problem is the tables. I want to sync and alter their structures on the production server using
mysqldump (or any other way that you can propose) without altering any existing data.
If it helps, I only want to add more columns, not remove any existing ones. Also, I am using
Is there any way to do this?