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

On Oct 31, 2007 3:22 AM, robert rottermann <robert@redcor.ch> 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=lists@pantek.com