I'm afraid this is a completly application-related question and not MySQL one.
Migrating data from old table format to the new one should be done using a specially made software for that (PHP, Perl, etc etc). You should read all data from old tables and insert them in the new ones. If you're changing to a new version of the same software, there must be some 'upgrade' script available which will do that for you automatically. Sincerily, Leonardo Rodrigues ----- Original Message ----- From: "Eric Wagar" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, February 16, 2004 10:43 PM Subject: Migrate from one MySQL table format to another Where do I find information on how to move data from one table format to another? I have a phpnuke site that uses a certain Journal program, and we'd like to use a new Journal program. Unfortunately, the tables and resulting structure are not the same. And, since they don't use the same tables/structures, I am afraid I'd lose the information already added. Where do I find information on how to migrate that data from one format to another? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]