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 5000000000. You can verify this effect by BEFORE makeing the change, use SHOW TABLE STATUS LIKE 'MYTABLE' . Then look at the max_data_length column. Before you change it will be this 4294967295 (4.0G), after your change it will be something like 1099511627775.
Yes, the error message does not make sense. I have not had time to build a test case to get to MySQL so they can give us a better error message. See this manual page for info on create table. http://www.mysql.com/doc/C/R/CREATE_TABLE.html You can just alter the table with this option. Hope this helps, Ken ----- Original Message ----- From: "Ovanes Manucharyan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 14, 2002 6:44 PM Subject: Large tables on FreeBSD > Hello, > > I need to create a table that is around 15 GB on a FreeBSD 4.5RELEASE system. > > I compiled mysql-3.23.49 without any extraneous flags such as (--disable-largefile) > > I use mysqlimport to import the table from a flatfile which is about 9GB. > > 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 doesn't help. > > > Ovanes > > > __________________________________________________ > Do You Yahoo!? > LAUNCH - Your Yahoo! Music Experience > http://launch.yahoo.com > > -------------------------------------------------------------------- - > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
