Re: No Data on table

2007-02-19 Thread Christian Hammers
On 2007-02-19 Nhadie Ramos wrote: > 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? Read http://www.suse.de/~aj/linux_lfs.html and google a bit. Basically any recent Kernel 2.4 or 2.6 should do

Re: No Data on table

2007-02-18 Thread Nhadie Ramos
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 sel

Re: No Data on table

2007-02-18 Thread Christian Hammers
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 F

No Data on table

2007-02-18 Thread Nhadie
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