MYSQL import, export, and restore backup

MYSQL import, export, and restore backup

The import and export mainly involve two Commands: source and MySQLdump:

1: Import: Enter the MySQL command line, enter any database to be imported, and then import. The specific command is as follows: Enter the Windows doscommand line '----------> mysql-u root-p -------------> enter the database Password ------> create database shujuku; ------------> use shujuku; ---------------> absolute path of the database file to be imported by source;

2: Export: Enter the doscommand line of windows, mysqldump-u root-p to export the database> the address you want to export;

Restoration is equivalent to import; backup is equivalent to export.