[BlueOnyx:03598] Re: MySQL Error

[Mark E. Levy]

I discovered that the .frm file for that table was still in the data
directory. I renamed it as a test and the associated site still worked, and
last night's backup ran without error.

Thanks.
-Mark

-----Original Message-----
From: blueonyx-bounces at blueonyx.it [mailto:blueonyx-bounces at blueonyx.it] On
Behalf Of Steve Howes
Sent: Sunday, February 14, 2010 9:29 AM
To: BlueOnyx General Mailing List
Subject: [BlueOnyx:03594] Re: MySQL Error

On 14 Feb 2010, at 15:23, Mark E. Levy wrote:

> I know that this isn't necessarily a BX problem, but someone here  
> might have an answer.
>
> I get the following error:
>
> mysqldump: Got error: 1146: Table 'ns9rc.SecurityImagesSession'  
> doesn't exist when using LOCK TABLES
> Error: Couldn't read status information for table  
> SecurityImagesSession ()
> mysqldump: Couldn't execute 'show create table  
> `SecurityImagesSession`': Table 'ns9rc.SecurityImagesSession'  
> doesn't exist (1146)
>
> When I try to add that table  through phpMyAdmin, I get:
>
> #1050 - Table 'SecurityImagesSession' already exists
>
> How can I resolve this?
>

What does the mysql log say? Table might be a bit broken..

S
_______________________________________________
Blueonyx mailing list
Blueonyx at blueonyx.it
http://www.blueonyx.it/mailman/listinfo/blueonyx