Mailing List
Home
Forum Home
MySQL General - General MySQL discussion
MySQL++ - Programming with the C++ API to MySQL
MaxDB - Everything about MaxDB, formerly known as SAP DB
ODBC - ODBC with the MySQL Connector/ODBC driver
MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP
Java Help - Mostly related to the MySQL Connector/J driver
Perl - Perl support for MySQL with DBI and DBD::mysql
GUI - MySQL GUI Tools
Announcement
Subjects
• Subject: mysql openssl Question
• ERROR 1045: Access denied for user: 'root@localhost ' (Using
password: NO)
• Update one field with more fields from another table
• Subject: Getting Identity after INSERT
• ERROR 2002: Can 't connect to local MySQL server through socket
• mysql test 4 1 fails with the gis test
• Subject: MySQL Cluster Software
• Downgrade Mysql from 4 to 3 23
• Mysql 4 0 Oracle Stored Procedure Trigger Conversion
• Can 't access mysql after kernel upgrade
• Executing MySQL Commands From Within C Program
• Comparing and writing out BLOBS
• Subject: Re: Preventing Duplicate Entries
• FULLTEXT query format question
• Strange behavior, Table Level Permission
• Does the binary log enabling affect the MySQL performances?
• mysql:it 's a db not a dbms how it 's possible?!
• mysql have same function mthod as Oracle decode()
 
Subject: Re: mysql claims table does not exist. but it does

Subject: Re: mysql claims table does not exist. but it does

2007-11-03       - By Kim Briggs

 Back
On Oct 31, 2007 3:22 AM, robert rottermann <robert@(protected)> wrote:
> 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
>
Hi List,

For what it is worth, I have been using linux-based stuff for the last
7 years.  Each and every time I have a problem with something "not
existing" it has boiled down to a matter of permissions.  100% in my
experience.

HTH,
--
http://kimbriggs.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=mysql@(protected)