Re: Large tables on FreeBSD

2002-05-15 Thread Ken Menzel
Hi Ovanes, Even if you have large file support you must tell mysql to use long pointers when creating the table. The way to accomplih this is to add the MAX_ROWS table option when creating the table, just make it a really large number like 50. You can verify this effect by BEFORE mak

RE: Large tables on FreeBSD

2002-05-15 Thread Jay Blanchard
[snip] I watch the .MYD file grow to about 4.2 GB and stop with this error from mysqlimport. mysqlimport: Error: Can't open file: 'temp.MYD'. (errno: 144) mysqlimport: Error: The table 'temp' is full, when using table: temp I've tried starting safe_mysqld with the --big-tables option, and that d