When will you be able to copy InnoDB table space files to other systems and use the data there?

Question

Options

• AYou can always use them, because InnoDB files are platform independent.
• BBoth systems need to be either 32 Bit or 64 Bit platforms.
• CBoth systems need to run the same operating system.
• DBoth systems must be either little endian or big endian architecture.

• A
  82% (23)
• B
  11% (3)
• C
  4% (1)
• D
  4% (1)

Explanation

MyISAM tables and InnoDB tablespaces are binary portable from one host to another if two conditions are met: Both machines must use two's-complement integer arithmetic. Both machines must use IEEE floating-point format, or else the tables must contain no floating- point columns (FLOAT or In practice, those two conditions pose little restriction. Two's-complement integer arithmetic and IEEE floating-point format are the norm on modern hardware. A third condition for InnoDB binary portability is that you should use lowercase names for databases and tables.

No community discussion yet for this question.