MySQL DATA Export and Import (mysql Internal commands: mysqldump, mysql) backup database 1. export a database (all data, table structures, functions, and stored procedures are backed up) # mysqldump-BR database name-uroot-p password -- default-character-set = utf8> xxx. SQL 2. export specific tables and data (data and table structure) of a database # mysqldump database name-uroot-p password -- table Name> xxx. SQL 3. export all table structures of a database (excluding table data) # mysqldump-d database name-uroot-p password> xxx. SQL 4. export all table data of a database (excluding the table structure) # mysqldump-t database name-uroot-p password> xxx. SQL 5. export all functions and views of a database # mysqldump-dt-R database name-uroot-p password> xxx. SQL restoration database 1. import data to a database # mysql database name-uroot-p password <xxx. SQL