Use the mysqlmysqldump 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.

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.

Backup

The Code is as follows:
# Dump 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:
Mysqldump -- opt-d database name-u root-p> xxx. SQL

Export all, including data and data structure

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

Use source to import data

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