From: Luis Motta Campos Date: October 31 2011 5:32pm Subject: Re: importing mysql structures only or restore ignoring non-existing tables and columns? List-Archive: http://lists.mysql.com/mysql/226208 Message-Id: MIME-Version: 1.0 (Apple Message framework v1084) Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable On 29 Oct 2011, at 22:59, luci spam wrote: > I have 2 servers (1 for development, 1 for service) >=20 > I keep ADD/DELETE columns and CREATE/DELETE Indexes on my development > server, so these 2 server have similar but different mysql data = structures. >=20 > I know there's an option to expert structures only. (like =96no-data) >=20 > 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.) You can use SELECT...INTO DUMPFILE and LOAD DATA INFILE... to achieve = what I believe you're asking here, save the eventual misunderstanding. = ;-) Cheers -- Luis Motta Campos is a DBA, Foodie, and Photographer