TransWikia.com

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

Database Administrators Asked by geeves on December 4, 2021

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:

auth_history.frm
auth_hisotry.ibd
comments.frm
comments.ibd
db.opt
familymembers.frm
familymembers.MYD
familymemeber.MYI

etc.

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.

One Answer

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

Also, did you run mysql_upgrade?

Answered by Rick James on December 4, 2021

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP