MySQL Enterprise Encryption 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. • gen_dictionary_load( dictionary_path ,  dictionary_name ) Dictionaries are not persistent. Any dictionary used by applications must be loaded for each server startup. Important 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: 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: Example: 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/. 1593 6.6 MySQL Enterprise Encryption Note 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 | +-----------------------------------------+ •The  secure_file_priv  system variable is set and the dictionary file is not located in the directory named by the variable. •The dictionary file contains no terms. •The dictionary file is not found. •A dictionary with the given name is already loaded. • dictionary_name : A string that provides a name for the dictionary. • dictionary_path : A string that specifies the path name of the dictionary file.