Re: Upgraded from 5.1 to 5.5 but old databases do not appear

[Chris Sarris]

Well - I finally figured it out. Stranglely the official documentation doesn't clearly tell you how to migrate the data, users & permissions (called Grant Tables)

It turns out that MySql does not move the data for you when it does an Upgrade from 5.1 to 5.5 - so I had to move the data from one version to another.

A larger issue is that you can move the databases but you have to export your permissions (Grant Tables) from the "mysql" database (management database) and then re-run these Grant statements to import the new permissions for the migrated data.

I combed over the official documentation for a couple days and didn't find this clearly stated anywhere. This was very frustrating coming from a Microsoft SQL background.

The key for me was wasting a tremendous amount of time googling around the issue of "upgrading mysql 5.1 to 5.5" - over time I ran across bits that showed me I needed to be googing "mysql migrate grants" and that produced some very helpful articles.

This didn't have to be this difficult.

MySql guys - Add something obvious to your documentation about migrating data and permissions in databases. I should have hit a direct section on this in the MySql Reference Manual.