This article walks through a step‑by‑step troubleshooting of MySQL LOAD DATA LOCAL INFILE failures caused by date truncation, quoted CSV fields, and incorrect line terminators, showing how to enable local_infile, use enclosed‑by, @‑variables, and str_to_date to successfully import the data.
This article experimentally demonstrates how increasing the number of secondary indexes on MySQL tables progressively degrades write operations—including INSERT, UPDATE, DELETE, and LOAD DATA—by measuring execution times across ten tables with one to ten indexes each.
This article outlines a practical method for migrating MySQL tables with millions of rows by exporting data to an outfile, compressing, transferring, and loading it on the target server, while also addressing strict SQL mode errors that can arise during import.
The DBLE 3.21.02.0 release introduces ten new or refactored features, fixes over ten bugs, adds general logging, batch load data mode, fine‑grained SQL statistics, and other enhancements, while also detailing LTS updates, project overview, download links, and community acknowledgments.
The article evaluates MySQL 8.0.21's new ability to disable the InnoDB redo log, comparing load‑data performance with redo log enabled and disabled, and discusses practical implications, limitations, and safety considerations for bulk data import scenarios.
This article explains practical methods for importing various external data formats—such as CSV, plain text, XML, and JSON—into MySQL, covering command-line utilities, LOAD DATA statements, stored procedures, third‑party tools like mysqljsonimport, and using MySQL Workbench, while addressing configuration and security considerations.
