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
