Cannot access SQL table that I could access before

Asked Sep 18 '13 at 00:25

Active Sep 18 '13 at 00:25

Viewed 94 times

I've been working on a table inside a database, and now I cannot seem to access it. It says that the table "doesn't exist." Any help would be appreciated. Here are steps I'm taking to try and access it.

Ajay-Rameshs-iMac:~ ajay$ mysql -u root -pmypassword SOUsers
    mysql> show tables;
+-------------------+
| Tables_in_sousers |
+-------------------+
| userData          |
+-------------------+
1 row in set (0.00 sec)
mysql> select * from userData;
ERROR 1146 (42S02): Table 'sousers.userdata' doesn't exist

Any help would be much appreciated! In case it's important, I'm running this on OSX Lion Terminal.

Thanks!

~Carpetfizz

asked Sep 18 '13 at 00:25

Carpetfizz

8,707
22
85
146

1

take a look at this, hope it helps: http://stackoverflow.com/a/11696069/26224 – muratgu Sep 18 '13 at 00:32
After trying what muratgu said, have you tried REPAIR TABLE userData USE_FRM ? – Tony Sep 18 '13 at 00:39
No, I'm the only one who uses the database, since it is on localhost. Also, I tried those commands and they did not work. – Carpetfizz Sep 18 '13 at 00:40
What value does `select @@lower_case_table_names;` return? Is it possible that setting has been changed? – Michael - sqlbot Sep 18 '13 at 04:43

Cannot access SQL table that I could access before

0 Answers0