Hi Joe, and all you other guys.
Is it possible to downgrade to MySQL 4 on a Fedora Core 6 box with Virtualmin Pro.
We was transfering all sites we host from our old FC4 box to our new FC6 both running VM Pro and ran into BIG problems with MySQL 5. Version 5 incompatible to version 4 and earlier and the change in behavior for joins gives me lots of problem... and when doing some googling on this problem I see there is a lot of folks with the same problem. And it doesen't look like there is a "workaround" for this. They suggest rewriting your code, which I understand is the best thing.
The solution for me is (hopefully) the possibility to downgrade to MySQL 4. At this point there's no time to recode all our pages. We have to have all sites moved to the new server by Monday night. (Our ecommerce/webshop alone contains about 1300 files with lots of MySQL queries)
Now all sites is back on the old server due to MySQL 5 breaking the sites/code!