Geek Answers Handbook

The table exists in the show tables, but does not exist when I try to select from it

I recently upgraded from Mavericks to Yosemite, and I needed to reinstall mysql, I reinstalled it with brew install mysql, but before I did this, I backed up the data folder. (I usually do this since it is faster than export and import :) and it usually works).

The problem is that after reinstalling after copying the data folder, I have all my databases, all my tables, but I have a special problem.

And this problem:

mysql> use eek
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+----------------------+
| Tables_in_eek        |
+----------------------+
| e_commentmeta        |
| e_comments           |
| e_links              |
| e_options            |
| e_postmeta           |
| e_posts              |
| e_term_relationships |
| e_term_taxonomy      |
| e_terms              |
| e_usermeta           |
| e_users              |
+----------------------+
11 rows in set (0.00 sec)

mysql> SELECT * FROM `e_links`;
ERROR 1146 (42S02): Table 'eek.e_links' doesn't exist

I have no results in looking for this problem, most of which have problems associated with other causes (for example, table name names with names.)

Any ideas?

+4
1

- , , ib_logfile0, ib_logfile1 ibdata1.

+4

More articles:


All Articles