Hello everyone,
Looking at the horrible performance of the actual hoster, I'm being somehow forced to switch for a new one.
Actually I'm looking for your advices on good strategy for a smooth migration process.
The current installation is a 1.2.15
The current MySQL version is 5.0.41
The future install: to be decided
The future MySQL version is 4.0.24 (yes I know it's an old version but that's what I'm being served with)
What do u think the best choice would be to migrate:
1. Upgrade the old install to 1.2.19 -> install the Database Management plugin -> Export data: install the new instance of 1.2.19 on Host2 -> install the Database Management plugin -> Import data
2. At the actual install 1.2.15 -> install the Database Management plugin -> Export data: install the new instance of 1.2.19 on Host2 -> install the Database Management plugin -> Import data
Don't know if this is possible as I don't know if the database structure has changed from 1.2.15 to 1.2.19
3.Move the old files via FTP the Host2 -> Export Database from MySQL5.0.41 to MySQL 4.0.24 in MYSQL4 comptibility mode ->Import sql in the new database.
The last thing I would like to do. Previous imports from mysql5 to 4 has always been a desaster
Am I looking at the right steps ?
Thanks a bunch for your input