Hi!
I am back from holiday!
I guess using SELECT INTO OUTFILE (= mysqldump)
and LOAD FROM INFILE is as fast as converting
InnoDB->MyISAM->InnoDB.
I assume Ryan has a file system with > 2 GB files?
The outfile or the MyISAM table will be very big.
If you do not have > 2 GB files then you have to
SELECT your table INTO OUTFILE in pieces, not the
whole table at a time.
Note that the new BLOB code is not well tested yet, though
I have not received any bug reports for it. It may be best to
experiment first with pieces of your table instead of doing
the whole, maybe several hours long, conversion at once.
Regards,
Heikki
http://www.innodb.com
Copied message:
.........................
On Sat, Jul 14, 2001 at 11:12:21PM -0500, ryc wrote:
> I have a table that were created using innobase compiled with 64kb
> page tables. Now I want to upgrade to the newer version of innobase
> that supports the larger row sizes but as it mentions on the
> innobase .39b download page ( http://www.innodb.com/download.html )
> I must export the tables, and then import them again after upgraded
> to the new innodb code. The table has > 10million rows and takes up
> 15-20 gigs of disk space, I dont think that mysqldump will work so
> well on this table.
By "work so well" do you mean "work quickly?"
It may be faste to convert the tables to MyISAM tables, upgrade, and
convert them back to InnoDB tables. But I've not compared the speed
of the two operations. It's more of a hunch.
Jeremy--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 <-- NEW
MySQL 3.23.29: up 28 days, processed 216,528,232 queries (86/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
