Security Considerations for LOAD DATA LOCAL 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. MySQL Shell and Local Data Loading 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 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: 1181 Table export utility util.exportTable() Exports a MySQL relational table into a data file, which can be uploaded to a MySQL server instance using MySQL Shell’s parallel table import utility, imported to a different application, or used as a logical backup. The utility has preset options and customization options to produce different output formats. Parallel table import utility util.importTable() Inports a data file to a MySQL relational table. The data file can be the output from MySQL Shell’s table export utility or another format supported by the utility’s preset and customization options. The utility can carry out input preprocessing before adding the data to the table. It can accept multiple data files to merge into a single relational table, and automatically decompresses compressed files. Instance dump utility util.dumpInstance() , schema dump utility util.dumpSchemas() , and table dump utility util.dumpTables() Export an instance, schema, or table to a set of dump files, which can then be uploaded to a MySQL instance using MySQL Shell’s dump loading utility. The utilities provide Oracle Cloud Infrastructure Object Storage streaming, MySQL Database Service compatibility checks and modifications, and the ability to carry out a dry run to identify issues before proceeding with the dump. Dump loading utility util.loadDump() Import dump files created using MySQL Shell’s instance, schema, or table dump utility into a MySQL Database Service DB System or a MySQL Server instance. The utility manages the upload process and