content_image/707340.jpg
case-sensitive regardless of the case sensitivity of the underlying file system. If the option value is the empty string, it names no directory, with the result that no files are permitted for local data loading. 

• mysqlimport  sets MYSQL_OPT_LOAD_DATA_LOCAL_DIR  for each file that it processes so that the directory containing the file is the permitted local loading directory. 

•For data loading operations corresponding to LOAD DATA  statements, mysqlbinlog  extracts the files from the binary log events, writes them as temporary files to the local file system, and writes LOAD DATA LOCAL  statements to cause the files to be loaded. By default, mysqlbinlog  writes these temporary files to an operating system-specific directory. The --local-load  option can be used to explicitly specify the directory where mysqlbinlog  should prepare local temporary files. 

Because other processes can write files to the default system-specific directory, it is advisable to specify the --local-load  option to mysqlbinlog  to designate a different directory for data files, and then designate that same directory by specifying the --load-data-local-dir  option to mysql  when processing the output from mysqlbinlog . 

## MySQL Shell and Local Data Loading 

MySQL Shell provides a number of utilities to dump tables, schemas, or server instances and load them into other instances. When you use these utilities to handle the data, MySQL Shell provides additional functions such as input preprocessing, multithreaded parallel loading, file compression and decompression, and handling access to Oracle Cloud Infrastructure Object Storage buckets. To get the best functionality, always use the most recent version available of MySQL Shell’s dump and dump loading utilities. 

MySQL Shell’s data upload utilities use LOAD DATA LOCAL INFILE  statements to upload data, so the local_infile  system variable must be set to ON  on the target server instance. You can do this before uploading the data, and remove it again afterwards. The utilities handle the file transfer requests safely to deal with the security considerations discussed in this topic. 

MySQL Shell includes these dump and dump loading utilities: 

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

