content_image/757260.jpg content_image/757252.jpg
• gen_dictionary_load( dictionary_path , dictionary_name ) 

Loads a file into the dictionary registry and assigns the dictionary a name to be used with other functions that require a dictionary name argument. 

This function requires the SUPER  privilege. 

<img src='content_image/757260.jpg'>

## Important 

Dictionaries are not persistent. Any dictionary used by applications must be loaded for each server startup. 

Once loaded into the registry, a dictionary is used as is, even if the underlying dictionary file changes. To reload a dictionary, first drop it with gen_dictionary_drop() , then load it again with gen_dictionary_load() . 

Arguments: 

• dictionary_path : A string that specifies the path name of the dictionary file. 

• dictionary_name : A string that provides a name for the dictionary. 

Return value: 

A string that indicates whether the load operation succeeded. Dictionary load success  indicates success. Dictionary load error  indicates failure. Dictionary load failure can occur for several reasons, including: 

•A dictionary with the given name is already loaded. 

•The dictionary file is not found. 

•The dictionary file contains no terms. 

•The secure_file_priv  system variable is set and the dictionary file is not located in the directory named by the variable. 

Example: 

mysql> SELECT gen_dictionary_load(’/usr/local/mysql/mysql-files/mydict’,’mydict’); +---------------------------------------------------------------------+ | gen_dictionary_load(’/usr/local/mysql/mysql-files/mydict’,’mydict’) | +---------------------------------------------------------------------+ | Dictionary load success | +---------------------------------------------------------------------+ mysql> SELECT gen_dictionary_load(’/dev/null’,’null’); +-----------------------------------------+ | gen_dictionary_load(’/dev/null’,’null’) | +-----------------------------------------+ | Dictionary load error | +-----------------------------------------+ 

## 6.6 MySQL Enterprise Encryption 

<img src='content_image/757252.jpg'>

## Note 

MySQL Enterprise Encryption is an extension included in MySQL Enterprise Edition, a commercial product. To learn more about commercial products, https:// www.mysql.com/products/. 

