At 12:09 PM 01/09/2002, Dan Nelson wrote: >In the last episode (Jan 08), Dennis said: > > We have a database that seems to have grown too large, and now any > > operation fails on it. How can we fix this? > >If you can SELECT from it, create a new MYISAM table with the RAID >option, or create an INNODB table with multiple 2gb tablespace files. >Then "INSERT INTO newtable SELECT * FROM oldtable". > >If you can't select from it, you might have to run myisamchk to repair >the table, or transfer the table to an OS that does not have the 2gb >limit and split the table there. > >-- > Dan Nelson > [EMAIL PROTECTED]
is the 2GB limit only in linux 2.2? (ie does 2.4 not have that limit?). Running a 2.4 kernel is the easiest option in that case. Dennis --------------------------------------------------------------------- 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
