MySQL Forums
Forum List  »  Newbie

lost tables
Posted by: Jim Sawyer
Date: August 30, 2016 01:24PM

I had a problem which made me restore my drive to a prior copy. I got all but 8 of my 80 mysql tables back, and can restore the rest except one. I have the database as
vettest
I have (or had) a file called
invoice
when I type
describe invoice;
mysql telles me
'vettest.invoice' doesn't exist
but when I try to create the table from the template it tells me
Tablespace 'vettest.invoice' exists.

How can I just remove all evidence of invoice so I
can construct it without that message?

Thanks,
Jim Sawyer

Options: ReplyQuote


Subject
Written By
Posted
lost tables
August 30, 2016 01:24PM
August 30, 2016 01:44PM
August 30, 2016 02:54PM
August 30, 2016 02:21PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.