Mysqldump Data Export

Mysqldump-u database user name-r database name > file name

Export database table structure + function + procedure + trigger

Do not export trigger you need to specify Trigger=false

Example:

Mysqldump-u database user name-R--trigger=false Database name > file name

Mysqldump-u database user name-p-n-t-d-r database name > file name

- N: --no-data do not export data

-T:--no-table does not export the data table structure

-D:--no-create-db do not export CREATE database information

-R: Export function and procedure

Other parameters to use:

-x : before starting the export, the commit request locks all tables in all databases to ensure data consistency. This is a global read lock, and the--single-transaction and--lock-tables options are turned off automatically

Mysqldump Data Export