MySQL Forums
Forum List  »  Other Migration

migration from one mysql database to another
Posted by: alex rongas
Date: May 28, 2008 01:53PM

Hello,
I am kind of newbie, also i am not sure if i post to the correct place. Appologies for this..

I have a database, on mysql, used from a program of mine. I wish to move to a next version of this program. However, this new program, has some extra tables/elements. Is there a way, to take the data of the original database, export them on some format i.e. CSV and then import the data to the new version (of the database) by including default values to the table entries that do not exist in the "CSV" data file?
If not, is there a way to export data to a CSV format and then parse them by myself?

Last...(sorry for many and long questions..), how is this done in reall comersial applications? when migrating from one version to another, how is this done in order not to make the CSV parser (that i mention) for every version towards every version?

Thanx a lot in advance!!! :-)

Options: ReplyQuote


Subject
Views
Written By
Posted
migration from one mysql database to another
5326
May 28, 2008 01:53PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.