I have 2 servers (1 for development, 1 for service) I keep ADD/DELETE columns and CREATE/DELETE Indexes on my development server, so these 2 server have similar but different mysql data structures.
I know there's an option to expert structures only. (like –no-data) Is there a way (except 3rd party software like mysqldiff.org) to import structure only to an existing data? Alternativley, is there a way to import only data ignoring non-existing tables and colums? (I thought this may do the trick if I back-up data -> import structure -> restore the data.) thanks in advance
