I followed the setup in below link, to setup mysql. Basically, I am have a master on OS X server and want to setup a linux slave.
Create a mysql slave database from master database
After I copied the data from macosx to linux, all the tables are found correctly except innodb. The database name was databasePE.
When I start database, I get error that databasepe/innodb_table_name.ibd is not found. I created a symlink from databasepe to databasePE.
If I use databasepe, then innodb tables would work, but myisam tables won't work.
ERROR 1146 (42S02): Table 'databasePE.myisam_table' doesn't exist
If I use databasePE, then innodb tables won't work, but myisam tables would work.
ERROR 1146 (42S02): Table 'crashtracerPE.innodb_table' doesn't exist
OS X use case insensitive file names, and this was never the problem on OS X. But, as linux uses case sensitive file names, it could not find the tables.
I tried setting lower_case_file_system=ON, but mysqld threw error.
130227 13:52:59 [ERROR] /usr/sbin/mysqld: unknown variable 'lower_case_file_system=ON'
I tried setting lower_case_table_names=2, but mysqld threw below error and reverting it back to zero.
130227 14:05:11 [Warning] lower_case_table_names was set to 2, even though your the file system '/mnt/data2/maindb/db/' is case sensitive. Now setting lower_case_table_names to 0 to avoid future problems.
Finally, after renaming databasePE to databasepe and setting lower_case_table_names=1, myisam and innodb tables are working correctly.
I am still not sure, whether to start replication because, master on OSX uses lower_case_table_names = 2, where as linux slave uses lower_case_table_names=1.
