MySQL Import and Export tool mysqldump and Source command usage detailed

mysqldump-u User name-P [--opt] DATABASENAME [Table] > Export SQL file name

Example:

Mysqldump-h host-u user-p--opt databasename [table] >/home/user/databasename.sql

Exporting a data table structure using mysqldump

mysqldump-u root-p--no-data mysql user >d:\phpweb\sqlbackup\mysql_user.sql

MySQL Database Import command source detailed

mysql most commonly used database Import command is the use of SOURCE,SOURCE commands is very simple, first you need to enter the MySQL database command line management interface, and then select the database to import, that is

USER Database
source exported SQL file

MySQL Import and Export tool mysqldump and Source command usage detailed