Originally Posted by Dr_Michael
Are there any known issues regarding the upgrade of mysql from 4 to 5? I mean are there any known scripts which may face problem with mysql 5?
I have a dedicated server with mysql 4.1.22 and I am looking to upgrade to mysql 5 but I worry for my clients hosted. Some of them are using very old scripts such as oscommerce, phpbb, yabb, etc.
Yes, you are right it create problem, few months before i have upgraded a ticket system their database structure is based on mysql 4.x and i was updating on mysql 5.x, i just did it for testing and after that make ticket system for testing with updated structure, it is not working, as it should be expected, then i have reviewd the forums and did the patches of database, after that everything looks fine. I suggest you will do one by one on a testing server then after fixing the all issues deploy in production server. My database was 34 GB, it took me 2 days to continue patching without any break.