Several common parameters for MySQL import and export

Export command:

Mysqldump-t--skip-extended-insert-utest-p TestDB TableA > Testdb_tablea.sql

Parameter description:

- T: Export data only, without schema (build table, Index)

--skip-extended-insert: Export INSERT statement One row of data, the default option is all data one insert

－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－

Import command:

Mysql-f-h127.0.0.1-utest-p TestDB <./testdb.sql

Parameter description:

- F: enforced, ignoring errors. For example, importing data often encounters an insert primary key repeat error, and this option can be used to continue execution regardless of the error.