After restoring a mysql backup in AWS RDS, I get "table doesn't exist":
Server version: 5.7.22-log Source distribution
mysql> show tables;
+----------------------------+
| Tables_in_db |
+----------------------------+
| foo |
...
mysql> select * from foo;
ERROR 1146 (42S02): Table 'db.foo' doesn't exist
This error is all around serverfault and stackoverflow. The suggestion is usually to stop servers, examine files in the file system, and so on.
I don't think I have access to the server or the filesystem on AWS. Am I hosed?
How do I even file a ticket against AWS?
EDIT: I removed a stray period above, because it wasn't in the real example. This stray period (now gone) caused someone to do some amazing debugging below, but that's not my issue.
Also, I found out how to file a ticket against AWS here.