I reinstalled XAMPP which included MySQL. Prior to the reinstall, I made a backup of the 'C:\xampp\mysql\data' subdirectory, which is where all the databases are stored.
When the new install finished, I copied back the databases in the 'data' subfolder into 'c:\xampp\MySQL\data'. I then went to MySQL Workbench to see if I can access any of them. Refreshing the view made all the databases appear, but when I do a SELECT on any of the tables in any of those databases, I keep getting a message that says the table does not exist, so apparently something is wrong.
How can I make the new install of MySQL see my databases as it used to? Thanks.