Mysqldump data structure and database backup restoration method

Mysql tutorial dump data structure and database tutorial backup restoration method

Mysqldump stores the SQL commands for the output table structure and data in a text file.
C: mysqlbinmysqldump-u <username>-p <database> [<table>]> file. SQL

Back up database

C: mysqlbinmysqldump-u root-p mydatabase> mydatabase. SQL

We can also choose to output only a table from the database, such as the employee table:

C: mysqlbinmysqldump-u root-p mydatabase employee> employee. SQL

C: mysqlbinmysqldump-u root-p -- all-databases> alldb. SQL

Data restoration

C: mysqlbinmysql-u root-p mydatabase <mydatabase. SQL

Add a table or database that does not exist at all

C: mysqlbinmysql-u root-p mydatabase <employee. SQL

Provides a remote database backup

C: mysqlbinmysqldump-u root-p -- databases mydatabase |
> Mysql-u backup-p mypassword-h remote.server.com