0

i have a really weird situation. I'm using netbeans to create simple java applications and Mysqlworkbrench to manage the Mysql database. Everything on MacOS Mountain Lion. Until now, everything was normal but today something happened. I was trying my application on netbeans like always but suddenly, the application gave me an error telling me that it could not find a table from my Database. I went to MysqlWorkbrench to check the database and my surprise was that my database is there with all the tables, but all the tables without the info (or i can't access them) and when i make right click on a table, and select "edit table data" i got this error "Error Code: 1146. Table 'enterprise.categories' doesn't exist". This is crazy because i was using this table for a long time ago. This situations is the same for all the rest of the tables. Thanks!

Joaquin Pereira
  • 205
  • 2
  • 14
  • You have not asked a question. – Sotirios Delimanolis Aug 14 '13 at 17:15
  • Does this answer: http://stackoverflow.com/a/11696069/616460 apply? Did you try and copy the database files? Did you do anything out of the ordinary when this behavior started? A file permissions issue? Are there any errors in a log anywhere? And, just in case, do you have a backup of your database available? – Jason C Aug 14 '13 at 17:18
  • Restore DB from backups. – Martin James Aug 14 '13 at 17:18
  • @SotiriosDelimanolis I think the implied question is "What the heck is going on here?" Of course, that still doesn't make it the best post for SO. (Give the OP some credit for using good tags, though.) – Jason C Aug 14 '13 at 17:19
  • For Sotirios > "Does anyone knows something about this?" – Joaquin Pereira Aug 14 '13 at 19:33
  • i just tried everything but i can't get this works. I just wanna add something that i forgotten. last night, when everything works normal, I just put my laptop on stand by and this morning when i opened it to continue working with my project, i ran into this situation. – Joaquin Pereira Aug 14 '13 at 20:38
  • Do you people know any code to make mysql-backups directly from a java applicacion? i would like to insert a funtion that allow to user, make backups and get away of this weird bug. – Joaquin Pereira Aug 14 '13 at 20:48
  • Have you refreshed the schema tree on the left (e.g. via context menu) before you accessed the table that gave you this error in MySQL Workbench? Are you 100% sure the schema still exists? To me it sounds like you deleted the schema and now your tools tell that fact. – Mike Lischke Aug 15 '13 at 07:08

0 Answers0