469,903 Members | 2,034 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,903 developers. It's quick & easy.

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

abdoelmasry
104 100+
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 ??
Sep 11 '07 #1
17 77254
pbmods
5,821 Expert 4TB
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
Expand|Select|Wrap|Line Numbers
  1. SHOW TABLES;
.
Sep 11 '07 #2
abdoelmasry
104 100+
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
Sep 11 '07 #3
code green
1,726 Expert 1GB
Do you have the relevant permissions?
Sep 12 '07 #4
abdoelmasry
104 100+
yes code green

im using mysql with full control permissions im the root
Sep 13 '07 #5
code green
1,726 Expert 1GB
This is a mystery. If you are convinced the table is corrupted and they are MyISAM you could run
Expand|Select|Wrap|Line Numbers
  1. 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?
Sep 14 '07 #6
pbmods
5,821 Expert 4TB
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`?
Sep 14 '07 #7
abdoelmasry
104 100+
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:
Expand|Select|Wrap|Line Numbers
  1. +-----------+--------+----------+---------------------------------+
  2. | Table     | Op     | Msg_type | Msg_text                        |
  3. +-----------+--------+----------+---------------------------------+
  4. | job.pages | repair | error    | Table 'job.pages' doesn't exist |
  5. +-----------+--------+----------+---------------------------------+
  6.  
i gonna be mad
Sep 15 '07 #8
pbmods
5,821 Expert 4TB
Heya, Abdoelmasry.

What do you get when you issue a SHOW TABLES?
Sep 15 '07 #9
abdoelmasry
104 100+
hi pbmods

I got all database tables

Command :

Expand|Select|Wrap|Line Numbers
  1. show tables;
Result:

Expand|Select|Wrap|Line Numbers
  1. +---------------+
  2. | Tables_in_job |
  3. +---------------+
  4. | cpanelstyle   |
  5. | cptags        |
  6. | cpusers       |
  7. | forms         |
  8. | pages         |
  9. | parts         |
  10. | phrase        |
  11. | styles        |
  12. +---------------+
and this is All database (job) tables .
Sep 16 '07 #10
pbmods
5,821 Expert 4TB
Heya, Abdoelmasry.

Are any of the other tables giving you trouble? Or is it just the `pages` table?
Sep 16 '07 #11
abdoelmasry
104 100+
Hi pbmods

all Database tables have the same problem

I cann't use any table of 'job' database
Sep 16 '07 #12
pbmods
5,821 Expert 4TB
Heya, Abdoelmasry.

Are these InnoDB tables or MyISAM tables?

Did you just recently upgrade your MySQL version?
Sep 16 '07 #13
abdoelmasry
104 100+
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
Sep 16 '07 #14
pbmods
5,821 Expert 4TB
Heya, Abdoelmasry.

Have a look at this document.
Sep 16 '07 #15
abdoelmasry
104 100+
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
Sep 17 '07 #16
pbmods
5,821 Expert 4TB
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.
Sep 17 '07 #17
abdoelmasry
104 100+
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
Sep 17 '07 #18

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by Edwin Knoppert | last post: by
3 posts views Thread by tshad | last post: by
3 posts views Thread by =?Utf-8?B?S2F5xLFoYW4=?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.