MySQL Data import and export

1. Navicat for Mysql

The XML Export import format supports binary data; Although the synchronization data does not see the difference, but Java attempts to read the data, the value of the DateTime field is quoted as "0000-00-00 00:00:00", can not find the reason;

2. Mysqldump Data Export

1) Export:

Mysqldump-h <ip>-P <port>-u <user> <database> <table>-p > <table>.sql

2) Import:

Mysql-h <ip>-P <port>-u<user> <database>-P < <table>.sql

Or

Mysql> Source <table>.sql

3) Just table structure Withou records

Mysqldump--opt-d-H <ip>-P <port>-u <user> <database> <table>-p > <table>.sql

MySQL Data import and export