MySQL Forums
Forum List  »  MySQL for Excel

Re: Is possible to export MySQL query results from Visual Studio into Excel
Posted by: Javier Treviño
Date: September 25, 2015 12:54PM

Hi Rudolf,
The problem you are getting is because the secure-file-priv system variable on the MySQL Server you are connecting to is limiting import/export operations to a specific directory only.

This is for security purposes, and whoever setup the MySQL Server may have done this in purpose. The global variable cannot be changed dynamically, if you have admin privileges and can access the MySQL config file you can try to change the setting or look at what folder it is limiting the output so you use the same folder in your SELECT statement.

For more information please refer to the MySQL Server documentation:
https://dev.mysql.com/doc/refman/5.7/en/server-options.html#option_mysqld_secure-file-priv

Best regards.

====================================
Javier Treviño
MySQL on Windows Team

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Is possible to export MySQL query results from Visual Studio into Excel
1184
September 25, 2015 12:54PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.