• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

mysql database migration issues

 
jim li
Ranch Hand
Posts: 180
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

we are trying to migrate data with old schema into database with new schema, such as

in database, in old schema , table 'person' it has 'first_name' and 'last_name',

in new schema , table 'person' it has 'first_name' and 'last_name' and 'age'

we are researching some tools or ways to export data with old schema into database with new schema ,

please give me some adivce.

thank you
 
Karsten Wutzke
Ranch Hand
Posts: 106
Hibernate MySQL Database Python
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ahm plain CSV files? You can use phpMyAdmin to import the old stuff into MySQL with ease. Also see a command called LOAD DATA INFILE.

Note your question has nothing to do with ORM. Please visit the MySQL forums.

Karsten
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic