Table full error

scoutt · #1 (**permalink**) 12-10-02, 16:47

it tells me
mysql error: The table 'SQLc37_0' is full

I know that it is a temp table but how do I make it bigger?

I have tried this
mysql_query("SET BIG_TABLES = 1");

but to no avail. I know the path to temp table but don't know howt o set it to 1. does anybody have an idea??

I have read the mysql manual but I am useing 3.22 so some commands are in it yet.

I started getting this error when my row got over 80,000.

noodle · #2 (**permalink**) 12-10-02, 18:10

Have you tried searching for it at mysql.com?

scoutt · #3 (**permalink**) 12-10-02, 18:19

that is why I said I read the manual...

scoutt · #4 (**permalink**) 12-13-02, 10:16

nobody know how to do this????