Migrate mysql Data from Windows to Linux.

Migrate mysql Data from Windows to Linux.

1. First, set data on windowsExportOne file. (Take a database as an example)

Export the entire database mysqldump-u user name-p Password Database Name> export the exported file name export the specified table mysqldump-u user name-p Password Database Name table name 1 Table name 2...> exported file name

2. Copy data from Windows to Linux.

3. log on to the MySql database of Linux

4. Create a database name with the same name as windows.

Mysql> create database qt; check whether the character set is consistent with that of windows. If the character set is inconsistent, modify it accordingly. Mysql> show create database qt; mysql> alter database qt character set utf8; mysql> show create database qt;

5. Import Data

6. view results

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.