Mysql-based data management and mysql Data Management

Mysql-based data management and mysql Data Management
Preparation Note: mysqldump.exeis the data import tool of the mysqldata warehouse server ( mysql.exe)

 

1. Data Backup

• Store data on the database server in a local SQL File

Mysqldump.exe-h host name [-p port number]-u username-p password [-d] dbname [tablename]> c:/file. SQL

Note: The terminal must run win7 (com + r input cmd) win10 (com + x SELECT command prompt) in administrator mode)

Take win10 as an Example

A. Operation Result

Exported SQL File

 

 

What is Data Structure? What is data,

Data Structure: Only attributes of fields are included in exported database files. No other information is provided to ensure data security (personal understanding)

Export the structure and data of the database file

Syntax: remove d and the exported database file has the structure and data.

Mysql.exe-h host name [-p port number]-u user name-p password dbname <c:/file. SQL

Result;

 

• Data restoration

Syntax:

Mysql.exe-h host name [-p port number]-u user name-p password dbname <c:/file. SQL