Pantek Library
Hosting Provided By
CybrHost
High Speed Hosting

mysql claims table does not exist. but it does

From: robert rottermann <robert(at)redcor.ch>
Date: Wed Oct 31 2007 - 03:22:50 EDT


Hi there,
I have a strange problem.

I am using Server version: 5.0.45 SUSE MySQL RPM

I made a backup of a database by copying its directory like so: mv urulu urulu_X
then I recreateded the database, played a little with it and then dropped it again.
the I moved the old database in place again. now when I want to access the tables of the database I get an error that the tables do not exist, alltough the showtables lists them correctly.

what can I do to fix that?
to explayin thin a bit better, here a dump of an mysql dialog

mysql> use urulu
Database changed
mysql> show tables;

+------------------+

| Tables_in_urulu |
+------------------+

| dataccess |
| datancestors |
| datchildren |
| datserialisation |
| datstat |
| datvariables |
| datwidgets |
| defchildren |
| defdependencies |
| defgeneral |
| defhandler |
| defvariables |
| lang |
| session |
| synaccess |
| synconnect |
| syncreate |
| syndata |
| synproperties |
| syntoc |
| xslcache |
+------------------+

21 rows in set (0.00 sec)

mysql> select * from lang;
ERROR 1146 (42S02): Table 'urulu.lang' doesn't exist mysql>

thanks
robert

-- 
MySQL General Mailing List
For list archives: 
http://lists.mysql.com/mysql
To unsubscribe:    
http://lists.mysql.com/mysql?unsub=lists@pantek.com
Received on Wed Oct 31 03:24:16 2007
Do you need help?X

This archive was generated by hypermail 2.1.8 : Thu Jul 03 2008 - 08:43:51 EDT


Contact Us  Legal Notices  Order Services Online 
Pantek Home  Privacy Policy  IT news  Site Map  Pantek Library