Apparently you have to compile for large file support and have glibc > 2.1.3. http://www.suse.de/~aj/linux_lfs.html
I have not used it so I do not know the real-world limitations. Or (for 100MB files): mysqldump db table |split -b 100000000 - table --Bill Mike Lucente wrote: > I'm also unable to create files >2GB with mysqldump, even after a > recompile with gcc 2.96, RH 7.1 w/2.4.2 kernel, glibc 2.2.2. > > hmmm ... > > On Wed, 3 Oct 2001, Adams, Bill TQO wrote: > > > Perhaps your index file (.MYI) is growing larger than 2GB, the file-size > > limit on 2.2.x kernels? > > > > Or, if you have moved the tables with symlinks, MySQL will put the new file > > (most of the time?) in the configured data directory and not where the > > symlink points. > > > > --Bill > > > > > > > > Mike Lucente wrote: > > > > > I'm running out of space while creating indexes on some fairly large (1.8 > > > GB) tables, even though I have quite a bit of space available in the > > > partition (utilization is at 30%). > > > > > > I know that the create process works as follows (from the manual): > > > > > > Create a new table named `A-xxx' with the requested changes. > > > All rows from the old table are copied to `A-xxx'. > > > The old table is renamed `B-xxx'. > > > `A-xxx' is renamed to your old table name. > > > `B-xxx' is deleted. > > > > > > Given that, I should have plenty of room. Disk utilization doesn't appear > > > to exceed 60% during the process. > > > > > > Any idea what could be causing this? > > > > > > ** Running RH 7.1 on a Dell 2450. MySQL version 3.23.29a-gamma-log. > > > > > > --------------------------------------------------------------------- > > > 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 > > > > -- > > Bill Adams > > TriQuint Semiconductor > > > > > > > > > > --------------------------------------------------------------------- > > 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 -- Bill Adams TriQuint Semiconductor --------------------------------------------------------------------- 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