New Structure + Old Data = Error?

[Tayuke]

I've been working on my database, but every so often, there's new database settings that need to be added. So, I export the old data from the old table, then export also the structure from the new table I then create a new database, ad the structure, then all its data…unofortinulay, it doesn't work, for some odd reason. I've checked over the new table config, and look at old config table, and there are no major changes…just a few new fields.

Any suggestions. I'm thinking its got something to do with the way I backup the structure…is there any way I should do it?

[peterlaursen]

A small 'test case, would have been nice .. and “it doesn't work, for some odd reason” does not tell much.  What EXACTLY happens.  We cannot advice from the knowledge on what does not happen – we need to know what does happen!

If the INSERT statements are in the form ('full inserts')

INSERT INTO tablename (col1,col2,..,coln) values (val1,val2,..,valn) 

.. it should work. The short form 

INSERT INTO tablename values (val1,val2,..,valn) 

won't if structure was changed

But why do'nt you not just ALTER TABLE form SQLyog when you need to add columns ???

[Author]

Posts