Hi Christian,
Thanks for the reply. I got the table repaired and deleted some data on it.
What combination can i use to overcome the 4GB limit?
TIA
Regards,
Nhadie
Christian Hammers wrote:
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]
