IMPORT TABLE FROM sdi_file [, sdi_file] ...

The IMPORT TABLE statement imports MyISAM tables based on information contained in .sdi (serialized dictionary information) metadata files. IMPORT TABLE语句根据.sdi（序列化字典信息）元数据文件中包含的信息导入MyISAM表。IMPORT TABLE requires the FILE privilege to read the .sdi and table content files, and the CREATE privilege for the table to be created.IMPORT TABLE需要FILE权限来读取.sdi和表内容文件，并且需要创建表的创建权限。

Tables can be exported from one server using mysqldump to write a file of SQL statements and imported into another server using mysql to process the dump file. 可以使用mysqldump从一台服务器导出表来编写SQL语句文件，然后使用mysql将表导入另一台服务器来处理转储文件。IMPORT TABLE provides a faster alternative using the “raw” table files.IMPORT TABLE使用“原始”表文件提供了更快的替代方法。

Prior to import, the files that provide the table content must be placed in the appropriate schema directory for the import server, and the .sdi file must be located in a directory accessible to the server. 导入之前，提供表内容的文件必须放置在导入服务器的相应架构目录中，.sdi文件必须位于服务器可以访问的目录中。For example, the .sdi file can be placed in the directory named by the secure_file_priv system variable, or (if secure_file_priv is empty) in a directory under the server data directory.例如，可以将.sdi文件放在由secure_file_priv系统变量命名的目录中，或者（如果secure_file_priv为空）放在服务器数据目录下的目录中。

The following example describes how to export MyISAM tables named employees and managers from the hr schema of one server and import them into the hr schema of another server. 下面的示例描述如何从一台服务器的hr架构导出名为employees和managers的MyISAM表，并将它们导入另一台服务器的hr架构。The example uses these assumptions (to perform a similar operation on your own system, modify the path names as appropriate):该示例使用这些假设（要在自己的系统上执行类似的操作，请根据需要修改路径名）：

To export tables from the export server, use this procedure:要从导出服务器导出表，请使用以下步骤：

To import tables into the import server, use this procedure:要将表导入导入导入服务器，请使用以下过程：

The .sdi file need not be placed in the import server directory named by the secure_file_priv system variable if that variable is empty; it can be in any directory accessible to the server, including the schema directory for the imported table. 如果secure_file_priv系统变量指定的导入服务器目录为空，则不需要将.sdi文件放在该目录中；它可以位于服务器可访问的任何目录中，包括导入表的架构目录。If the .sdi file is placed in that directory, however, it may be rewritten; the import operation creates a new .sdi file for the table, which overwrites the old .sdi file if the operation uses the same file name for the new file.但是，如果.sdi文件放在该目录中，它可能会被重写；导入操作为表创建一个新的.sdi文件，如果操作对新文件使用相同的文件名，则会覆盖旧的.sdi文件。

Each sdi_file value must be a string literal that names the .sdi file for a table or is a pattern that matches .sdi files. 每个sdi_file值必须是一个为表命名.sdi文件的字符串文字，或者是一个与.sdi文件匹配的模式。If the string is a pattern, any leading directory path and the .sdi file name suffix must be given literally. 如果字符串是一个模式，则任何前导目录路径和.sdi文件名后缀必须按字面给出。Pattern characters are permitted only in the base name part of the file name:仅允许在文件名的基名称部分使用模式字符：

Using a pattern, the previous IMPORT TABLE statement could have been written like this (assuming that the /tmp/mysql-files directory contains no other .sdi files matching the pattern):使用模式，前面的IMPORT TABLE语句可以这样编写（假设/tmp/mysql-files目录不包含与模式匹配的其他.sdi文件）：

IMPORT TABLE FROM '/tmp/mysql-files/*.sdi';

To interpret the location of .sdi file path names, the server uses the same rules for IMPORT TABLE as the server-side rules for LOAD DATA (that is, the non-LOCAL rules). 为了解释.sdi文件路径名的位置，服务器使用与加载数据的服务器端规则（即非本地规则）相同的IMPORT TABLE规则。See Section 13.2.7, “LOAD DATA Statement”, paying particular attention to the rules used to interpret relative path names.请参阅第13.2.7节，“加载数据语句”，特别注意用于解释相对路径名的规则。

IMPORT TABLE fails if the .sdi or table files cannot be located. 如果找不到.sdi或表文件，则IMPORT TABLE失败。After importing a table, the server attempts to open it and reports as warnings any problems detected. 导入表后，服务器将尝试打开它，并将检测到的任何问题报告为警告。To attempt a repair to correct any reported issues, use REPAIR TABLE.要尝试修复以更正任何报告的问题，请使用REPAIR TABLE。

IMPORT TABLE is not written to the binary log.IMPORT TABLE未写入二进制日志。

{
   "mysqld_version_id":80019,
   "dd_version":80017,
   "sdi_version":80016,
   ...
}