为何出现表格不存在的提示？

Question

请下载数据，解压后，复制到mysql的data文件夹里面。

https://pan.baidu.com/s/1GWKE...

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| guestbook          |
| lyb                |
| mysql              |
| performance_schema |
+--------------------+
5 rows in set (0.06 sec)

我发现guestbook的数据可以使用。

mysql> use lyb;
Database changed
mysql> show tables;
+---------------+
| Tables_in_lyb |
+---------------+
| admin         |
| author        |
| cart          |
| city          |
| link          |
| lyb           |
| lyb1          |
| messages      |
| news          |
| province      |
| route         |
| shop          |
+---------------+
12 rows in set (0.00 sec)

mysql> select * from admin;
ERROR 1146 (42S02): Table 'lyb.admin' doesn't exist
mysql> select class from lyb;
ERROR 1146 (42S02): Table 'lyb.lyb' doesn't exist
mysql>

明明存在表格，为何会这样？

Answer 1

请问楼主是怎么创建的这些表?如果是复制的数据文件的话,参考一下下面这个链接

https://blog.csdn.net/e_wsq/article/details/63704574