MySQL-数据库导入-恢复方法

MySQL-数据库导入-恢复方法 (MySQL - Database Import - Recovery Methods)

There are two simple ways in MySQL to load data into the MySQL database from a previously backed up file.

MySQL中有两种简单的方法可以将数据从先前备份的文件加载到MySQL数据库中。

使用LOAD DATA导入数据 (Importing Data with LOAD DATA)

MySQL provides a LOAD DATA statement that acts as a bulk data loader. Here is an example statement that reads a file dump.txt from your current directory and loads it into the table mytbl in the current database.

MySQL提供了一个LOAD DATA语句，可以用作批量数据加载器。 这是一个示例语句，该语句从当前目录读取文件dump.txt并将其加载到当前数据库的表mytbl中。

mysql> LOAD DATA LOCAL INFILE 'dump.txt' INTO TABLE mytbl;

• If the LOCAL keyword is not present, MySQL looks for the datafile on the server host using the looking into absolute pathname, which fully specifies the location of the file, beginning from the root of the filesystem. MySQL reads the file from the given location.

  如果没有LOCAL关键字，MySQL将使用对绝对路径名的查找在服务器主机上查找数据文件，该路