Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
Home » Performance » MySQL » InnoDB tablespace inter-version compatibility
InnoDB tablespace inter-version compatibility [message #547] Mon, 08 January 2007 16:04 Go to next message
dinky is currently offline dinky
Messages: 4
Registered: September 2006
Location: Toronto, ON
Junior Member
Interestingly enough, MyISAM files could be taken from version 4.x into mysql 5, and they seem to working fine, of 'course with _some_ exception described in http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.ht ml Smile
But I could not found any info about possible innodb compatibility or opposite - can ibdata file be moved from any 4 to 5 version of MySQL? Common sense tell me "no", but why it's missing in docs? Or I must've overlooked it Sad
Report message to a moderator
Re: InnoDB tablespace inter-version compatibility [message #548 is a reply to message #547 ] Mon, 08 January 2007 16:35 Go to previous messageGo to next message
inner is currently offline inner
Messages: 13
Registered: November 2006
Location: Lithuania
Junior Member
Hi,

The exceptions for InnoDB are also mentioned in the same article. So you can make an upgrade, but it's recomended either to redump the data anyway. In some cases `mysql_upgrade` after upgrade may help you.

// Aurimas

// Aurimas
Report message to a moderator
Re: InnoDB tablespace inter-version compatibility [message #549 is a reply to message #548 ] Mon, 08 January 2007 16:41 Go to previous messageGo to next message
dinky is currently offline dinky
Messages: 4
Registered: September 2006
Location: Toronto, ON
Junior Member
yeah, I read that before, couldn't find anything related to my case Smile Also tried to copy ibdata and log files from 4 to 5 - mysql crashes with "mysqld got signal 10;" when trying to run any select query...
Report message to a moderator
Re: InnoDB tablespace inter-version compatibility [message #550 is a reply to message #549 ] Mon, 08 January 2007 16:52 Go to previous message
inner is currently offline inner
Messages: 13
Registered: November 2006
Location: Lithuania
Junior Member
Interesting. As I understand, only queries to InnoDB tables crash the MySQL daemon, right? Do these statements modify the data or do they only try to select it? Have you tried to dump any InnoDB table? What are the minor mysql versions you are upgrading from and to?

// Aurimas
Report message to a moderator
Previous Topic:Making query shorter
Next Topic:Two general MySQL questions..
Goto Forum:
  

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [ ]

Current Time: Sun Jul 5 14:56:45 EDT 2009

Total time taken to generate the page: 0.01448 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 2.7.7.
Copyright ©2001-2007 FUD Forum Bulletin Board Software

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.