Hello On 2007-02-18 Nhadie wrote: > 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?
It seems that you are using a combination of MySQL + Kernel + Filesystem + Unix Distribution that is not capable of writing files larger than 4GB. That was a known limitations until some years ago. If you can, then copy those tables to a "recent" computer and execute a "REPAIR TABLE" on them. If they end up with >4GB then delete as much as necessary and they will be usable on your old computer again. HTH, -christian- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]