Error code 1114: The table is full

[Cedric Pillonel]

When inserting a new item into a table, I get the following error:

Unable to insert into RBSRecordTable, error code 1114: The table 'RBSRecordTable' is full

select count(*) from RBSRecordTable;
+----------+
| count(*) |
+----------+
| 23967602 |
+----------+
1 row in set (0.02 sec)

I have about 24 millions entries in that table. Is that the max?

I am running MySQL 4.1.22 on RH Linux ES 4, 32bits. All my tables are using the MyISAM engine. I have enough disk space, my ibdata1 file is about 10Gb. Here is my "my.cnf" file:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
log-bin
binlog-do-db=Billing

# Disabling symbolic-links is recommended to prevent assorted security risks;
# to do so, uncomment this line:
# symbolic-links=0

[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

The file "RBSRecordTable.MYD" is about 4GB. I think that is the problem, on linux this is the max file size. Can you confirm that the MySQL error is due to the file size limit of Linux?

Thank you.