Deep MySQL Import and export

MySQL Common Export Data command:
1.mysql exporting the entire database
Mysqldump-hhostname-uusername-ppassword databasename > Backupfile.sql
Mysqldump-hlocalhost-uroot hqgr> Hqgr.sql (if the root user does not use the password can not write-p, of course, the exported SQL file you can develop a path, not specified in the MySQL bin directory)

2.mysql Export Database A table
Mysqldump-hhostname-uusername-ppassword database tablename> exported file name
Mysqldump-hlocalhost-uroot hqgr t_ug_user> User.sql

3.mysql Exporting a database structure
mysqldump-hhostname-uusername-ppassword-d--add-drop-table Databasename>d:hqgrstructure.sql
-D No data--add-drop-table add a drop table before each CREATE statement

4. If you need to export a function or stored procedure inside MySQL
  mysqldump-hhostname-uusername-ppassword-ntd-r databasename > Backupflie.sql
  mysqldump-hlocalhost-uroot-ntd-r hqgr > Hqgr.sql
  where-NTD is the export stored procedure;-R is the export function

MySQL common command to import data:
1.mysql command
  Mysql-hhostname-uusername-ppassword databasename < backupfile.sql
2.source command
  Mysql>source backupfile.sql