MYSQLDUMP data structure and database backup restore method

MySQL Tutorial dump data structure and database tutorial backup Restore method

Mysqldump output table structure and data a series of SQL commands stored in a text file
C:mysqlbinmysqldump-u <username>-P <database> [<table>] > File.sql

Backing up a database

C:mysqlbinmysqldump-u root-p mydatabase > Mydatabase.sql

We can also choose to output just 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 restore

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