Buy Percona SupportEmergency? Get 24/7 Help Now!


Percona Server has extended the SELECT INTO ... OUTFILE and SELECT INTO DUMPFILE commands to add the 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 which wastes space and I/O.

Version Specific Information

Other Reading

This documentation is developed in Launchpad as part of the Percona Server 5.5.
If you spotted inaccuracies, errors, don't understood it or you think something is missing or should be improved, please file a bug.

General Inquiries

For general inquiries, please send us your question and someone will contact you.