Unistalled MySQL 5.6 and installed MySQL 5.7 – Restore Database and Tables

Posted on

Question :

All of the data resides in “C:ProgramDataMySQLMySQL Server 5.6data”. 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:



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.

Answer :

The “user” that logged into Workbench did not have permissions to see the rest of the databases.

Also, did you run mysql_upgrade?

Leave a Reply

Your email address will not be published. Required fields are marked *