On Tue, Jul 16, 2002 at 07:49:27PM -0500, mos wrote: > > With InnoDb you need to pre-allocate file space so all the tables get put > into one file. This is a good idea when you have a lot of people accessing > the database because it reduces the file handles (less work for the > operating system).
In recent versions, InnoDB will grow the space as needed (if you tell it to do so). > You need to unload the database data with MySQLDump or an SQL > statement. Or the InnoDB hot backup tool (an add-on commercial product). Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 3.23.51: up 48 days, processed 1,026,565,214 queries (245/sec. avg) --------------------------------------------------------------------- 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