Hi! >From http://www.innodb.com/ibman.html :
.... MySQL/InnoDB-3.23.44, November 2, 2001 You can define foreign key constraints on InnoDB tables. An example: FOREIGN KEY (col1) REFERENCES table2(col2). You can create > 4 GB data files in those file systems that allow it. .... Thus > 4 G files should be available also on 4.0.1. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com "Gurupartap Davis" wrote in message ... >I'm using MySQL 4.0, trying to set up some innodb tables with several 20GB >data files, >but mysql is telling me that the files must be <= 4096MB > >This is on a RedHat 7.2 box with redhat's 2.4.9-13 enterprise kernel on a >reiserfs filesystem... > >I don't think there should be such a low limit...I accidentally made a 9GB >log file the other day. > >Is this a limit of innodb? Is there somewhere I can adjust this limit? > >Thanks >-Partap Davis >Syncrasy, LLC --------------------------------------------------------------------- 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