All of the data resides in "C:\ProgramData\MySQL\MySQL Server 5.6\data". There are 46 folders inside of this folder. There is one folder for every old database I had. For example the first three database are "509", "blog" and "bsp". Inside each of the folders, named after the database, are several files:
auth_history.frm auth_hisotry.ibd comments.frm comments.ibd db.opt familymembers.frm familymembers.MYD familymemeber.MYI
Only three tables show in MySQL Workbench, sakila,sys and world. These may be databases that come along with a complete install.
I'd like to get the old schemas and data back. How do I do that? I've tried several things, but reading binary files is not my strongest point.
All help is really appreciated. Several schemas had hundreds of tables and lots of data. Nothing is larger than 1/2 Gig.
I'm currently running MySQL 5.7 on a Windows 10 Pro machine.