Unix Technical Forum

No Data on table

This is a discussion on No Data on table within the MySQL General forum forums, part of the MySQL category; --> Hi All, Hope you can help me with this problem: I had an error that my database is already ...


Go Back   Unix Technical Forum > Database Server Software > MySQL > MySQL General forum

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-28-2008, 05:49 AM
Nhadie
 
Posts: n/a
Default No Data on table

Hi All,

Hope you can help me with this problem:

I had an error that my database is already full, when i do a select there is
always no result even select * from tablename.

but when i look at it on /var/lib/mysql i can see the size of the file is
still huge,

-rw-rw---- 1 mysql mysql 9174 Feb 18 11:46 tablename.frm
-rw-rw---- 1 mysql mysql 4294967092 Feb 18 11:49 tablename.MYD
-rw-rw---- 1 mysql mysql 782402560 Feb 18 11:52 tablename.MYI

which might mean that the data should still be in there somewhere, but how
can i retrieve it?

TIA

Regards
nhadie

________________________________________________
Message sent using UebiMiau 2.7

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 02:35 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com