Ispirer Ispirer
 

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

sqlways:troubleshooting-guide:mysql:import:command-not-allowed-data-load [April 26, 2019, 12:28:05 PM]
darya.prikhodkina [Solutions]
sqlways:troubleshooting-guide:mysql:import:command-not-allowed-data-load [July 25, 2019, 08:12:59 AM] (current)
alexandr.kirpichny
Line 36: Line 36:
  
 Both client and server should enable the local-file option. Otherwise it will not work. To enable it for files on the server side, add the following to the my.cnf configuration file: Both client and server should enable the local-file option. Otherwise it will not work. To enable it for files on the server side, add the following to the my.cnf configuration file:
-loose-local-infile = 1+ 
 +   loose-local-infile = 1 
 +    
 +Or if you have SUPER privileges, you can execute the following command on the server: 
 + 
 +   SET GLOBAL local_infile = 1; 
  
 More information about "loose-local-infile" option can be found here: __**[[https://dev.mysql.com/doc/refman/8.0/en/load-data-local.html|Security Issues with LOAD DATA LOCAL]]**__ More information about "loose-local-infile" option can be found here: __**[[https://dev.mysql.com/doc/refman/8.0/en/load-data-local.html|Security Issues with LOAD DATA LOCAL]]**__
Line 45: Line 51:
  
  
-If you don't see the "Advanced" button on this page, please switch the tool to the "Expert Mode". If you don't know how to do it, pleaserefer to this link: __**[[http://wiki.ispirer.com/sqlways/faq/expert-mode|How to Use SQLWays in Expert Mode]]**__+If you don't see the "Advanced" button on this page, please switch the tool to the "Expert Mode". If you don't know how to do it, please refer to this link: __**[[http://wiki.ispirer.com/sqlways/faq/expert-mode|How to Use SQLWays in Expert Mode]]**__
 \\ \\
  
sqlways/troubleshooting-guide/mysql/import/command-not-allowed-data-load.txt · Last modified: July 25, 2019, 08:12:59 AM by alexandr.kirpichny
 
© 1999-2019, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement