So I upgrade my Apple MacBook Pro to Snow Leopard and all is well until I go to access my MySQL Server installation (5.1.30 Community Edition). The install is completely fubared: The server won’t start. All my data files are there, but hardly accessible since to access them requires a good knowledge of the command line terminal and changing permissions on the data folder itself since it assigned to the _mysql user directly and not to the root user.
Looking around the interweb, I find a few people who claim that the Snow Leopard upgrade breaks the soft link to the mysql directory and that’s why it is screwed up. Well, fixing the soft link may have worked for other people, but not for me.
After spending and hour and a half putzing around with the command line trying to relink my old database files with a new install of 5.1.37, I decided to spend the ten minutes to recreate my databases and reload them from the backups I had made before the OS upgrade. See, backups are like the cavalry.
So after spending way too much time dealing with this fairly annoying upgrade problem, I was back were I needed to be. On the other hand, my MAMP installation survived the upgrade without a hitch. Go MAMP!
A mysterious voice from the past wishes you a very happy 43rd birthday. Hoping all is well with you.