[thelist] MySQL: transfer data to table with different structure?

Frank lists at frankmarion.com
Sun Mar 9 13:59:51 CDT 2008

I'm upgrading a client from a (very) previous version of a CMS that 
I've written to a newer version. I want to transfer their data over, 
but the table structures are slightly different. The tables and 
fields are essentially the same but have variation in naming schemes.

old setup->    articles.ArticleTitle
new setup->  pub_articles.article_title

Newer tables will have newer fields, and need not be affected.

Basically, I'm dealing with a byproduct/consequence of my own 
evolution as a coder.

Can someone suggest how I can setup some sort of batch transfer of 
data from one differing structure to another?


Frank Marion     lists at frankmarion.com      Keep the signal high.

More information about the thelist mailing list