Re: Unknown tables
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 mysql@lists.mysql.com Sent: Sunday, June 18, 2006 5:28 PM Subject: RE: Unknown tables 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 for file existance, permissions etc. I can't comment on InnoDB tables. Quentin The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Unknown tables
I'm not very experienced in this area, but I assume you mean to check the information_schema database and the schemata table? I checked there, and it is there. However, I've simply gone through the process of completely re-building my tables from scratch. I didn't receive any answers at all from this question, and I needed to move on with it, so I had no choice but to start from scratch. :-( The bit about the inno engine not starting is good to know, though. Thanks, Jesse - Original Message - From: Duzenbury, Rich [EMAIL PROTECTED] To: MySQL List mysql@lists.mysql.com 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 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Unknown tables
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 for file existance, permissions etc. I can't comment on InnoDB tables. Quentin The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Unknown tables
-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]