Oh, OK. Well, guess which driver I'm using... InnoDB. :-) Oh well.
Thanks,
Jesse
- Original Message -
From: "Quentin Bennett" <[EMAIL PROTECTED]>
To: "Jesse" <[EMAIL PROTECTED]>; "MySQL List"
Sent: Sunday, June 18, 2006 5:28 PM
Subjec
"but I assume you mean to check the
information_schema "database" and the schemata table?"
No, Rich meant
"check the mysql data directory for a karate directory."
MySQL databases (for MyISAM tables) are stored in their own directory, and each
table is a set of 3 files, so its easy to check f
IL PROTECTED]>
To: "MySQL List"
Sent: Wednesday, June 14, 2006 1:26 PM
Subject: RE: Unknown tables
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
> -Original Message-
> From: Jesse [mailto:[EMAIL PROTECTED]
> 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 c
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. Doe
