Thanks a ton Shawn, very illuminating. Will try this tomorrow with good hope. :)
BR /Kenneth
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: den 23 augusti 2005 16:50
To: Lindh Kenneth
Cc: mysql@lists.mysql.com
Subject: Re: The table '' is full
Hello.
Have a look here:
http://dev.mysql.com/doc/mysql/en/full-table.html
Your MySQL version is rather old, upgrade to 5.0.11.
"Lindh Kenneth" <[EMAIL PROTECTED]> wrote:
> When I run a query I get this error-message. It doesn't say which table, =
> but I checked all my tables and n
OK, I *DID* have a major cut and past mistake. In Part A the terms in
parentheses in the first CREATE...SELECT... statement should either be
erased or delimited as comments (your choice)
[EMAIL PROTECTED] wrote on 08/23/2005 10:49:33 AM:
>
> /* part A - collect the 'required' information */
"Lindh Kenneth" <[EMAIL PROTECTED]> wrote on 08/23/2005
07:52:23 AM:
> When I run a query I get this error-message. It doesn't say which
> table, but I checked all my tables and none is near max_table_size.
> We have MyISAM-tables and we're using version: 5.0.4
> Any ideas?
>
> BR /Kenneth
>
>
Hi,
There's no table size limit, but if you use InnoDB, maybe you need to
extend the size of your tablespaces, because they CAN be full. Check out
your my.cnf
Good luck,
Daniel
At 08:21 2002.09.06._ -0300, you wrote:
> Im inserting 6.000.000 records on a table... but in 3.500.000
http://www.mysql.com/doc/F/u/Full_table.html
> Hello,
>
> I tried to make a query to MySQL, the version is: mysql Ver 9.38 Distrib
> 3.22.32, for pc-linux-gnu (i686). The result should be about 4843 rows,
> but I got this message instead of the result:
> ERROR 1114: The table 'SQL22e0b00_0' is