> -----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 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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]