Use mysql mysqldump command to export and import data

Many of our friends prefer to use third-party tools to import and export data. In fact, our mysql comes with this tool, as long as it can be operated in command mode, of course, it can also be used in php. The method is the same as below. If you need it, refer to it.

Back up database

 

The Code is as follows:	Copy code
# Mysqldump Database Name> Database Backup name # Mysqldump-A-u username-p Password Database Name> Database Backup name # Mysqldump-d-A -- add-drop-table-uroot-p> xxx. SQL

Export Data Structure

The Code is as follows:	Copy code
Mysqldump -- opt-d database name-u root-p> xxx. SQL

Export all, including data and data structure

 

The Code is as follows:	Copy code
Mysqldump database name-uroot-p> xxx. SQL

Use source to import data

 

The Code is as follows:	Copy code
# Mysql database name <file name # Source/tmp/xxx. SQL