MySQL Forums
Forum List  »  Other Migration

MySQL data migration from 4.1.22 to 5.1.41
Posted by: Ramesh Kumar
Date: June 22, 2011 12:07AM

Hi,

My existing production setup MySQL version is 4.1.22. It has huge data (nearly 800 GB) and most of them are InnoDB tables. I would like to migrate the MySQL from 4.1.22 to 5.1.41. Since my database has huge data, it might take lot of time to run mysqldump and restore. So, can I try the below steps to migrate data from 4.1.22 to 5.1.41,

1. Stop MySQL 4.1.22
2. Move all the files from <MySQL 4.1.22>/data/<DB>/* to <MySQL 5.1.41>/data/<DB>/ directory.
3. Start MySQL 5.1.27

Can you please share your views on this approach? Will it work in all the cases ? Is there any other best way to do migration with less time ?

Thanks,
Ramesh



Edited 2 time(s). Last edit at 06/22/2011 12:11AM by Ramesh Kumar.

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL data migration from 4.1.22 to 5.1.41
4793
June 22, 2011 12:07AM


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.