Steps for restoring a MySQL database

This article mainly describes the actual restoration solution of the MySQL database and related syntaxes to be used. We all know that the files backed up by mysqldump are SQL scripts that can be directly imported, there are two main ways to import data.

Directly use the mysql client

For example:

 
 


  
  
/Usr/local/mysql/bin/mysql-uyejr-pyejr db_name <db_name. SQL

 
 

Use SOURCE syntax

In fact, this is not a standard SQL syntax, but a function provided by the mysql client, for example:

 
 


  
  
SOURCE/tmp/db_name. SQL;

 
 

Here, you need to specify the absolute path of the file, and the file must be read by the mysqld running user (such as nobody). The above content is an introduction to restoring the MySQL database, I hope you will have some gains.
 

The above content refers to the restoration of the MySQL database, hoping to help you in this regard.