How to change data structure in mysql using mysqldump without deleting files
- by Don Quixote
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 mysqlyog.
Is there any way to do this?