Table Full..
| From: | Hoo Kok Mun | Date: | Fri, 15 Sep 2000 13:19:04 +0000 |
| Subject: | Table Full.. | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-2923@lists.php.net to get a copy of this message | ||
I have another problem here.
My table has about 4700 records with about 27 fields.
I have tried the query a few times and it works with up to 1200+ records so far.
When I try for all records I have this error:-
SQL Error! The table 'SQLc3c_0' is full
My Linux is running MySQL 3.22.32 and PHP4.0.1.pl2.
It has 48MB RAM, 400MB free space, swap partition is 16MB.
What does this mean and how can I rectify it?
I searched the MySQL Manual again and couldn't find the error message.
Please advice, really appreciate all hte help that I can get.
BTW: I have tried -
Suggested by: Brittingham, John
SET OPTION SQL_BIG_TABLES=1
Done that but still has the same error.
Suggested by: David Patton
You need to increase the tmp_table_size setting...
Where do I set this variable?
Currently it was set to 1MB.
***************************************************************
"Don't be afraid to ask dumb questions, they are a lot easier to
handle than dumb mistakes."
Email : kokmun@familyhoo.netHome Page : http://www.familyhoo.net ***************************************************************