Extended SELECT INTO OUTFILE/DUMPFILE¶
Percona Server for MySQL has extended the SELECT INTO ... OUTFILE
and SELECT INTO
DUMPFILE
commands
to add support for UNIX sockets and named pipes. Before this was implemented
the database would return an error for such files.
This feature allows using LOAD DATA LOCAL INFILE
in combination with
SELECT INTO OUTFILE
to quickly load multiple partitions across the network
or in other setups, without having to use an intermediate file that wastes
space and I/O.
Version specific information¶
- 8.0.12-1: The feature was ported from Percona Server for MySQL 5.7.
Other reading¶
- MySQL bug: #44835
Get expert help¶
If you need assistance, visit the community forum for comprehensive and free database knowledge, or contact our Percona Database Experts for professional support and services.
Last update:
2023-09-27