I installed mysql with Homebrew about a year or so back and created some databases with it. I uninstalled it some time last year. The data files in /usr/local/var/mysql are still around.
I recently reinstalled mysql with Homebrew. Though it installed, the server would not start with the old data files in place. So I had to remove the old data files and reinstall to get the server to start.
I want to recover the databases created with the older version of mysql. I'm not sure if this can be done with the newer version of mysql installed or if I need to install the old version of mysql. If I have to install the old version, how can I determine what version of mysql was used to create the databases?
Note: these are innodb databases.