Can I use the LOAD DATA LOCAL for MySQL?
This specific command poses a security issue and has been disabled. To work around the issue, We have a number of options available to you, including: Work around for phpMyAdmin: If the file is the result of a MySQL dump then they can cut/copy & paste the contents into the query window. Work around for MySQL-Front: Using version 2.2, 2.3, or 2.4 (and not 2.5), simply use the “Import Text file” function to import .CSV files. REFERENCES FROM http://www.mysql.com/doc/en/LOAD_DATA_LOCAL.html: 4.2.4 Security issues with LOAD DATA LOCAL In MySQL 3.23.49 and MySQL 4.0.2, we added some new options to deal with possible security issues when it comes to LOAD DATA LOCAL. There are two possible problems with supporting this command: • As the reading of the file is initiated from the server, one could theoretically create a patched MySQL server that could read any file on the client machine that the current user has read access to, when the client issues a query against the table. • In a web enviro
This specific command poses a security issue and has been disabled. To work around the issue, We have a number of options available to you, including: Work around for phpMyAdmin: If the file is the result of a MySQL dump then they can cut/copy&paste the contents into the query window Work around for MySQL-Front: Using version 2.2, 2.3, or 2.4 (and not 2.5), simply use the “Import Textfile” function to import .CSV files. REFERENCES FROM http://www.mysql.com/doc/en/LOAD_DATA_LOCAL.html: 4.2.4 Security issues with LOAD DATA LOCAL In MySQL 3.23.49 and MySQL 4.0.2, we added some new options to deal with possible security issues when it comes to LOAD DATA LOCAL. There are two possible problems with supporting this command: As the reading of the file is initiated from the server, one could theoretically create a patched MySQL server that could read any file on the client machine that the current user has read access to, when the client issues a query against the table. In a web environment wh