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!
Downgrading MySQL can be a serious challenge…but in your case, I’m assuming you don’t have any new data in the MySQL 5 database? That’s the biggest problem with downgrading is getting the data to go downward (data that takes advantage of new features are impossible to import into the older version).
Let me see if I can build MySQL 4 packages for you real quick. I’ll let you know in about an hour whether it’ll be easy or not.
Downgrading MySQL can be a serious challenge…but in your case, I’m assuming you don’t have any new data in the MySQL 5 database? That’s the biggest problem with downgrading is getting the data to go downward (data that takes advantage of new features are impossible to import into the older version).
Let me see if I can build MySQL 4 packages for you real quick. I’ll let you know in about an hour whether it’ll be easy or not.
Downgrading MySQL can be a serious challenge…but in your case, I’m assuming you don’t have any new data in the MySQL 5 database? That’s the biggest problem with downgrading is getting the data to go downward (data that takes advantage of new features are impossible to import into the older version).
Let me see if I can build MySQL 4 packages for you real quick. I’ll let you know in about an hour whether it’ll be easy or not.
Have you hade time to check if it’s possible to do this?
Or could you just give me a hint on when you have time to check this up, would be nice to know because i’m starting to get these horrible thoughts of getting a couple hours of sleep… thats not a good thought
Downgrading MySQL can be a serious challenge…but in your case, I’m assuming you don’t have any new data in the MySQL 5 database? That’s the biggest problem with downgrading is getting the data to go downward (data that takes advantage of new features are impossible to import into the older version).
Let me see if I can build MySQL 4 packages for you real quick. I’ll let you know in about an hour whether it’ll be easy or not.
Have you hade time to check if it’s possible to do this?
Or could you just give me a hint on when you have time to check this up, would be nice to know because i’m starting to get these horrible thoughts of getting a couple hours of sleep… thats not a good thought
Downgrading MySQL can be a serious challenge…but in your case, I’m assuming you don’t have any new data in the MySQL 5 database? That’s the biggest problem with downgrading is getting the data to go downward (data that takes advantage of new features are impossible to import into the older version).
Let me see if I can build MySQL 4 packages for you real quick. I’ll let you know in about an hour whether it’ll be easy or not.
Have you hade time to check if it’s possible to do this?
Or could you just give me a hint on when you have time to check this up, would be nice to know because i’m starting to get these horrible thoughts of getting a couple hours of sleep… thats not a good thought
I’m uploading wholly untested packages now. I hope you’re on i386? You didn’t mention architecture, so I built for 386 first. x86_64 is building now, should be ready in half an hour or so.
Ah, finished uploading the 386 packages…Grab the packages here:
Uninstall MySQL 5 and then install the MySQL 4 packages. These cannot sit side-by-side (building packages that could do so is a monumental undertaking, and there’s no way I could do it on short notice…and without someone throwing lots of money at me!). But I get the impression you don’t care about MySQL 5.
If you are running on x86_64, give it a bit more time. I’ll ping this thread when they’re uploaded.
Oh, yeah…You’re going to have to make sure any remnants of MySQL 5 are removed from the system after uninstalling. If there’s anything in /var/lib/mysql, you’ll need to get rid of it. It’d be asking for trouble to leave MySQL 5 data lying around during the switch to version 4.
Downgrading MySQL can be a serious challenge…but in your case, I’m assuming you don’t have any new data in the MySQL 5 database? That’s the biggest problem with downgrading is getting the data to go downward (data that takes advantage of new features are impossible to import into the older version).
Let me see if I can build MySQL 4 packages for you real quick. I’ll let you know in about an hour whether it’ll be easy or not.
Have you hade time to check if it’s possible to do this?
Or could you just give me a hint on when you have time to check this up, would be nice to know because i’m starting to get these horrible thoughts of getting a couple hours of sleep… thats not a good thought
Oh, yeah…You’re going to have to make sure any remnants of MySQL 5 are removed from the system after uninstalling. If there’s anything in /var/lib/mysql, you’ll need to get rid of it. It’d be asking for trouble to leave MySQL 5 data lying around during the switch to version 4.
Downgrading MySQL can be a serious challenge…but in your case, I’m assuming you don’t have any new data in the MySQL 5 database? That’s the biggest problem with downgrading is getting the data to go downward (data that takes advantage of new features are impossible to import into the older version).
Let me see if I can build MySQL 4 packages for you real quick. I’ll let you know in about an hour whether it’ll be easy or not.
Have you hade time to check if it’s possible to do this?
Or could you just give me a hint on when you have time to check this up, would be nice to know because i’m starting to get these horrible thoughts of getting a couple hours of sleep… thats not a good thought
Oh, yeah…You’re going to have to make sure any remnants of MySQL 5 are removed from the system after uninstalling. If there’s anything in /var/lib/mysql, you’ll need to get rid of it. It’d be asking for trouble to leave MySQL 5 data lying around during the switch to version 4.
