Binary Portablity

Both MyISAM 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 DOUBLE)

A third condition for InnoDB binary portability is that you should use lowercase names for tables and databases.

   ☞ This is because InnoDB stores these names internally (in its data dictionary) in lowercase on Windows. Using lowercase names allows binary portability between Windows and Unix, to force the use of lowercase names, you can put the following lines in an option file:

[mysqld]
lower_case_table_names=1

To sum up,

MyIsam 

• 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 DOUBLE)

InnoDB

• 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 DOUBLE)
• Database and table names must use lowercase format

References: http://dba.stackexchange.com/questions/174/how-can-i-move-a-database-from-one-server-to-another