System Type: 64-bit
Windows Edition: Windows Server 2008 R2 Enterprise
Microsoft Windows Server: 6.1
MySQL Workbench Version: 6.3
I manage a multi-site WordPress and it has grown to 33,000 tables so it’s getting really slow. So I’m trying to optimize our installation. I’ve been working on a DEV server and end up deleting the whole site. Assuming that copying the live server is not an option at this point (and please trust me that it isn’t) can you please help me with the following:
I highlighted and copied tables from the live server to paste them into the DEV server folder. Workbench recognizes the table in the Schemas area but when I write a SELECT query, for an Innodb tables, it says that they don’t exist. The MyISAM tables, however, run successfully.
I’m just confused because I know the tables are in the right folder but for some reason they don’t query. I saw a solution that says to create the tables with a regular query and then overwrite them in the folder but this isn’t realistic for me because there are 33,000 tables. Do any of you have some ideas as to how I can get these Innodb tables working again?
Read more here: Innodb Tables Do Not Exist