About backup and restore of MySQL database

In the process of building a Web site often encountered file backup and restore, in case of the next use

Backup:

In the picture, the Blue line is the backup command, and WordPress is the name of the database to be backed up. ">" outputs the results to a file,/opt/wordpress.sql to back up the database to opt and named Wordpress.sql

Restores:

Upload the file backup file to your IP server first, then enter the command: mysql-uroot-p into the database

Next Enter:

Use WordPress     /var/nis/wordpress.sql   //Restore Database

IP can be entered for viewing

If you want to continue to modify the site content can enter the IP address after adding /wp-admin

About backup and restore of MySQL database