Submit Hint Search The Forums LinksStatsPollsHeadlinesRSS
14,000 hints and counting!

How to downgrade to an older version of MySQL UNIX
I run a number of web apps here in the house -- a copy of the macosxhints.com site, for instance, where I can experiment with changes before making them on the live site. I recently got rid of the machine I was using to host these sites, and migrated everything over to the Mac Pro. As part of that process, I had to install MySQL, which is basically a very simple operation. Just download the proper package from their downloads page, and run the installer.

When I did this, though, I didn't notice that the default download is MySQL version 5; for compatibility reasons, I actually wanted MySQL 4.1. Unfortunately, I got all the way through the install before I noticed that I had installed version 5. So I removed the MySQL 5 files in /usr/local, downloaded the 4.1 version, and ran its installer. Unfortunately, the installer told me I couldn't install 4.1, as I already had a newer version of MySQL on the machine -- even though I'd just deleted it.

After a bit of digging, I found the cause and the solution. The MySQL installer checks for the existence of other MySQL versions by looking in the /Library/Receipts folder, not by looking for an actual installed version of MySQL. So I deleted the MySQL receipts folder I found in /Library/Receipts (it was named something like mysql-standard-5.0.67-apple-darwin8.5.1-i686.pkg), then ran the 4.1 installer again. This time, MySQL installed without any problems, and my locally-hosted sites are up and running again.
    •    
  • Currently 1.89 / 5
  You rated: 3 / 5 (9 votes cast)
 
[16,059 views]  

How to downgrade to an older version of MySQL | 6 comments | Create New Account
Click here to return to the 'How to downgrade to an older version of MySQL' hint
The following comments are owned by whoever posted them. This site is not responsible for what they say.
How to downgrade to an older version of MySQL
Authored by: akrabat on Nov 12, '08 08:14:41AM

See also Uninstalling MySQL on Mac OS X Leopard.

Regards,

Rob...



[ Reply to This | # ]
How to downgrade to an older version of MySQL
Authored by: djfreak on Nov 12, '08 11:29:24AM

I have shuddered at the prospect of MySQL downgrades before (due to past experiences in early V. 4 days).

It's good to be reminded that it's really not that hard.



[ Reply to This | # ]
How to downgrade to an older version of MySQL
Authored by: adamiis111 on Nov 12, '08 06:02:26PM
You can also use the mysql40 sql mode. It may not be 100% but it's a better option if it works for your particular application:

http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html


[ Reply to This | # ]
How to downgrade to an older version of MySQL
Authored by: PCheese on Nov 12, '08 08:18:39PM

This hint isn't really about MySQL - it's about the Receipts directory. The solution is applicable to similar issues with a number of other software installation packages. Be forewarned, though, that you should revert all changes made by the installer before you delete the receipt and try to install an older version, or you may make things (including your system) unstable!



[ Reply to This | # ]
How to downgrade to an older version of MySQL
Authored by: leamanc on Nov 13, '08 10:35:04AM

Seems like this has been on OS X Hints before, or at least in the forums. I ran into this problem about four years ago...not needing to downgrade, but just re-install. I recall finding the /Library/Receipts solution here.

As others have mentioned, this hint can apply to a lot of other things besides MySQL. Anytime an installer package says "Upgrade" instead of "Install," but you are wanting to do a fresh install, check for a receipt and dump it.



[ Reply to This | # ]
How to downgrade to an older version of MySQL
Authored by: wOOge on Sep 08, '09 01:12:30PM

If you've installed MySQL 5.4.1 (or higher) you will also have to remove any *mysql* preference files from here:

/private/var/db/receipts/

...as well as any other receipts folder mentioned above.


---
wOOge
http://www.axonz.com



[ Reply to This | # ]