Backup and restoration of MySQL database in Linux _ MySQL

Linux MySQL database backup and restoration of the entire [root] # usrbinmysqldump-h127.0.0.1-uusername-ppassworddatabasenameoptshare1backup.sqlusrbinmysqldump: used to execute the program;-h: host name-u: database User-backup and restoration of the entire MySQL database in p Linux

[Root] #/usr/bin/mysqldump-h127.0.0.1-uusername-ppassword databasename>/opt/share/1/backup. SQL

/Usr/bin/mysqldump: The program used for execution;

-H: host name

-U: database user

-P: database password

Databasename: database name

>/Opt/share/1/backup. SQL: name of the exported file

The exported file is opened in this way and garbled characters are found in it. this is normal because no font is set during export, which does not affect the backup and restoration of database content.

Then use

[Root] #/usr/bin/mysql-h127.0.0.1-uusername-ppassword databasename2

Import data to databasename2

OK, finished!