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 [December 04, 2018, 03:40:07 PM]
alexandr.kirpichny
sqlways:troubleshooting-guide:mysql:import:command-not-allowed-data-load [December 04, 2018, 03:46:34 PM] (current)
alexandr.kirpichny
Line 33: Line 33:
  
  
-Please, note:+__**Please, note:**__
  
-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]]+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 following to the my.cnf configuration file: 
 +loose-local-infile = 1 
 + 
 +More information about "loose-local-infile" option you can find here: __**[[https://dev.mysql.com/doc/refman/8.0/en/load-data-local.html|Security Issues with LOAD DATA LOCAL]]**__ 
 + 
 + 
 + 
 +__**Please, note:**__ 
 + 
 + 
 +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]]**__
 \\ \\
  
-If you have any other questions, please feel free to contact our support team: [[[email protected]]]+ 
 + 
 +If you have any other questions, please feel free to contact our support team: __**[[[email protected]]]**__
  
  
sqlways/troubleshooting-guide/mysql/import/command-not-allowed-data-load.txt · Last modified: December 04, 2018, 03:46:34 PM by alexandr.kirpichny
 
© 1999-2018, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement