Submitted by Anonymous (not verified) on July 21, 2007 - 02:47.
I have just migrated from MySql 4.x to 5.x. At a first time I tray to use MySql Migrate Tool. Because of same huge tables MySql Migrate Tool hangs up and cannot complete the task. So I get an idea.
List of DB: PHPBB3 database and 5 my own databases in 3 languages (English, Polish, Danish)
Migration:
1. Start MySql administrator connecting to MySql 4.x
2. Start new backup project and backup databases.
3. Start MySql Query Browser connecting to MySql 5.x
4. In the file menu go to Open Sql Script and browse to your backup, then open backup file you just made.
5. Run the script.
6. After a 2 or 3 minutes you’ve gat all databases in MySql 5.x
Migrate from MySql 4.X to MySql 5.X.
I have just migrated from MySql 4.x to 5.x. At a first time I tray to use MySql Migrate Tool. Because of same huge tables MySql Migrate Tool hangs up and cannot complete the task. So I get an idea.
List of DB: PHPBB3 database and 5 my own databases in 3 languages (English, Polish, Danish)
Migration:
1. Start MySql administrator connecting to MySql 4.x
2. Start new backup project and backup databases.
3. Start MySql Query Browser connecting to MySql 5.x
4. In the file menu go to Open Sql Script and browse to your backup, then open backup file you just made.
5. Run the script.
6. After a 2 or 3 minutes you’ve gat all databases in MySql 5.x
Hope this can help somebody.