Migrating old data to new table

admin

Administrator
Staff member
Hi,

I need to migrate data from an old table to a new one. My plan is to do a dump but my trouble is that I only want to keep some of the fields. Eg:

The old table has these fields;
date, title, date_made, timestamp, body.

The new table has these fields;
date, title, body.

I need to dump only the data I want into the new table. Any idea on how to do a selective dump, oh and I'm talking mysql here.

Thanks for your time,
Billy
 
Back
Top