mysql5.5 database migration operation under Linux

Background:

MySQL migrated from the window platform to the Linux environment of the various problems, this version is 5.5, remember that the MySQL version should be consistent when the database is migrated. 1, MySQL on the window is not case-sensitive 1) whereis MySQL 2) cd/usr/share/mysql ls-all 3) copy a. c NF file to/etc/and renamed MY.CNF, and add the following under My.cnf file [mysqld] Character_set_server=utf8 init_connect= ' Set NAMES UTF8 ' l Ower_case_table_names = 1 4) Restart database, import database backup file

mysql5.5 database migration operation under Linux