`table` doesn't exist... but I'm sure it does!

[abdoelmasry]

Hi Men

i have real problem using mysql database

i make database for my site with mysql

it have very important data

but i think the database tables corrupted

when i use the command

[PHP]select * from table_name;[/PHP]

or

[PHP]describe table_name;[/PHP]

i always get this message:

[PHP]ERROR 1146 (42S02): Table 'job.pages' doesn't exist[/PHP]

im sure the table is exists but mysql server couldn't read it

i need data get back

Any Idea ??

[pbmods]

Heya, Abdoelmasry.

Changed thread title to better describe the problem (did you know that threads whose titles do not follow the Posting Guidelines actually get FEWER responses?).

Are you using the correct database (jobs)?

Try executing

SHOW TABLES;

.

[abdoelmasry]

Hi pbmods

im sorry For bad title

when i execute : SHOW TABLES;

i can see all database tables

but i cannot treat them

you Know ??

I cann't drop any of them

Any one help plz

[code green]

Do you have the relevant permissions?

[abdoelmasry]

yes code green

im using mysql with full control permissions im the root

[code green]

This is a mystery. If you are convinced the table is corrupted and they are MyISAM you could run

REPAIR TABLE tablename

.
Never used it, and it should be used with caution.
Are you sure you are looking at the right database and using the correct table name?

[pbmods]

Heya, abdoelmasry.

Are you working on a case-sensitive filesystem? Are you matching the spelling and the capitalization of your table name?

Is, for example, the table named `Pages` or `PAGES`, but you're trying to access a table named `pages`?

[abdoelmasry]

Hey Men

im sure that im useing the correct characters case

my database name is 'job'

when i tried to repair any database table by using this command:

[PHP]repair table pages;[/PHP]

i got this error:

+-----------+--------+----------+---------------------------------+
| Table     | Op     | Msg_type | Msg_text                        |
+-----------+--------+----------+---------------------------------+
| job.pages | repair | error    | Table 'job.pages' doesn't exist |
+-----------+--------+----------+---------------------------------+
 

i gonna be mad

[pbmods]

Heya, Abdoelmasry.

What do you get when you issue a SHOW TABLES?

[abdoelmasry]

hi pbmods

I got all database tables

Command :

show tables;

Result:

+---------------+
| Tables_in_job |
+---------------+
| cpanelstyle   |
| cptags        |
| cpusers       |
| forms         |
| pages         |
| parts         |
| phrase        |
| styles        |
+---------------+

and this is All database (job) tables .

[pbmods]

Heya, Abdoelmasry.

Are any of the other tables giving you trouble? Or is it just the `pages` table?

[abdoelmasry]

Hi pbmods

all Database tables have the same problem

I cann't use any table of 'job' database

[pbmods]

Heya, Abdoelmasry.

Are these InnoDB tables or MyISAM tables?

Did you just recently upgrade your MySQL version?

[abdoelmasry]

i used mysql 5 to create this database ('job')

and

i installed new system copy and new mysql copy

but it's the same version mysql 5

i think it couldn't be form changing operating system

it's InnoDB tables

[pbmods]

Heya, Abdoelmasry.

Have a look at this document.

[abdoelmasry]

thank U man

all database tables have extension .frm

no other extensions

i tried another solution

i created new database then put 'job' tables files in the new directory of new database

but i have the same problem i can't (describe , select , repair , drop) any table

i checked every table size , i found that all tables have the same size

it's 9 kb so im sure this tables not carring data

i created new table the checked it's size , it's 9 kb

so i can say all tables are corrupted and i can't get it back

if i could repair any table .. what about size ??

thank you guys for tryying

[pbmods]

Heya, Abdoelmasry.

What you need to do is create a new database and set up your tables...

... and then go into the filesystem and physically copy the old database table files (*.frm) into the new database folder.

[abdoelmasry]

hey pbmods

i tried that but it's not working

the problem with the tables

if i changed database name or directory

i still have problem

Thank U Man

i will start my job with new database