Travis,
Travis Pierce wrote:
<snip>
check table shows:
------------------------------------------------------------------------------------------------------------------------
Status checked for table eventum.eventum_mail_queue.
Datafile is almost full, 4294967056 of 4294967294 used
------------------------------------------------------------------------------------------------------------------------
Status checked for table eventum.eventum_mail_queue.
OK
What does this mean and how do I fix this?
I'm running mysql 4.1.11-nt on windows 2000.
I don't have all the technical details, but basically the table has a
set amount of data it can handle, and it has reached that limit. The
good news is that is easily changed, just run this query.
ALTER TABLE eventum_mail_queue MAX_ROWS=4294967295 AVG_ROW_LENGTH=10000;
For more details, look here:
http://dev.mysql.com/doc/refman/4.1/en/create-table.html (search for
'AVG_ROW_LENGTH' or 'MAX_ROWS'.
Best Regards,
Are you MySQL certified? www.mysql.com/certification
5 messages in com.mysql.lists.eventum-usersRe: Datafile is almost full, 42949670...