Database migration using mysql...?

[prabhu rangan]

Hi Members,

Great to meet you all here.

Currently we are releasing our application with some major changes, so hardly we have to make some database changes:

Changes are:
1. we removed a column from a table and added a new column to that table.
2. we added a new column to a table

I have to write a script to migrate the older data to new database, with this changes,

Please help me in this and share your views.

I need some sample script to do this changes...

Looking forward for your reply.

Regards,
Prabhu.