MySQL Export Export database

The default export path is MySQL's built-in path, so ~/documents/is added as a path. Export the entire database

- - > ~/ Documents/Test.sql

Exporting a database table

Mysqldump-h hostname-u username-p Password database table_name> exported file name

- - > ~/ Documents/Takes.sql

Export a database structure

- - -p password  ---add-drop-table database_name> filename.sql

-D No data--add-drop-table add a drop table before each CREATE statement

Export a function or stored procedure inside MySQL

- - - - - >  ----> hqgr.sql

Where-n TD is the export stored procedure, and-R is the export function to recover the database from the backup file

[database name] < [backup file name]

 

MySQL Export Export database