Somehow, during an operation, I lost more than one table, which had both a structure defined, and actual data in it.ĥ.

I am using Navicat's table designer to lay out and design the table structures and relationships between them, then syncing back to the database.Ĥ. I am running (from memory) MySQL 5.6.12 on iMac OS X 10.7.ģ. I am assuming I'm using the InnoDB engine, though I'm not familiar with it enough to know.Ģ. I looked into it briefly since it was late, and I kind of got the idea that if I just flushed the tablespace on the offending tables (see example below), the problem should resolve itself. My problem is as follows: Somehow, while setting up a database last night, I did something that caused me to run into the 'tablespace already in use' issue (or whatever it's called). I ran into my first bona fide MySQL problem that I'm at a loss to fix, but which I'm sure someone will have some advice on. I started using MySQL several months ago at home with Navicat Premium for MySQL. I am a new user to this forum so please bear with me.

What is as good as navicat for mysql