LOAD DATA LOCAL LOAD DATA LOCAL INFILE LOAD INDEX INTO CACHE LOAD INDEX INTO CACHE ... IGNORE LEAVES LOAD XML LOAD XML ... IGNORE LOAD XML LOCAL LOCK TABLES LOCK TABLE LOCK INSTANCE FOR BACKUP Section 13.1.10, “ALTER TABLESPACE Statement” Section 15.1.2, “Best Practices for InnoDB Tables” Section 8.6.2, “Bulk Data Loading for MyISAM Tables” Section 13.1.12, “CREATE DATABASE Statement” Section 8.11.3, “Concurrent Inserts” Section 8.14.3, “General Thread States” Section B.3.6.1, “Problems with ALTER TABLE” Section 6.2.2, “Privileges Provided by MySQL” Section 5.1.8, “Server System Variables” Section 1.3, “What Is New in MySQL 8.0” Section 13.2.8, “LOAD XML Statement” Section 13.1.20.6, “CHECK Constraints” Section 13.1.2, “ALTER DATABASE Statement” Section 13.1.20.6, “CHECK Constraints” Section 13.1.20.10, “Invisible Columns” Section 13.2.8, “LOAD XML Statement” Section 24.1, “Overview of Partitioning in MySQL” Section 24.5, “Partition Selection” Section 5.1.11, “Server SQL Modes” Section 1.3, “What Is New in MySQL 8.0” Section 13.7.8.5, “LOAD INDEX INTO CACHE Statement” Section 13.7.8.2, “CACHE INDEX Statement” Section 8.10.2.4, “Index Preloading” Section 13.7.8.5, “LOAD INDEX INTO CACHE Statement” Section 13.3.3, “Statements That Cause an Implicit Commit” Section 13.2.7, “LOAD DATA Statement” Section 4.5.1.1, “mysql Client Options” Section 2.9.7, “MySQL Source-Configuration Options” Section 4.6.9, “mysqlbinlog — Utility for Processing Binary Log Files” Section 6.1.6, “Security Considerations for LOAD DATA LOCAL” Section 5.1.8, “Server System Variables” Section 6.1.6, “Security Considerations for LOAD DATA LOCAL” 5940