> -----Original Message-----
> From: Jesse [mailto:jlc@stripped]
> Sent: Monday, June 12, 2006 1:48 PM
> To: MySQL List
> Subject: Unknown tables
>
> When I do a SHOW TABLES in MySQL, it shows me a list of tables. But
when
> I
> try to do a "select * from countries", I get the error ERROR 1146
(42S02):
> Table 'karate.countries' doesn't exist. I cannot drop the table. I
> cannot
> drop the entire schema, and I cannot view the tables themselves. Does
> anyone know how to fix this problem? I'm using MySQL 5.0 on a Windows
XP
> Pro (my development machine) environment.
>
> Thanks,
> Jesse
I think there are lots of possible reasons, but first thing to do is to
check the mysql data directory for a karate directory. Look inside it.
That's where your tables should be.
I had a problem not too long ago where a table I wanted to work with was
an innodb type table, but because of a config file issue, the innodb
storage engine wouldn't start. So, the table was there, but because
innodb wasn't active, weird things like that were happening.
