MySQL data migration from 4.1.22 to 5.1.41
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.
Subject
Views
Written By
Posted
MySQL data migration from 4.1.22 to 5.1.41
4966
June 22, 2011 12:07AM
2158
July 19, 2011 06:49AM
2050
July 19, 2011 07:15AM
2100
July 29, 2011 09:34AM
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.