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 [May 16, 2018, 11:15:26 AM]
alexandr.kirpichny [Solutions]
sqlways:troubleshooting-guide:mysql:import:command-not-allowed-data-load [May 24, 2018, 08:29:20 AM] (current)
vera.bonda
Line 8: Line 8:
 === Symptoms === === Symptoms ===
  
-During the data import to MySQL version 8.0.2 and higher, you may see an error "ERROR 1148 (42000): The used command is not allowed with this MySQL version". +While importing data to MySQL version 8.0.2 and higher, an error "ERROR 1148 (42000): The used command is not allowed with this MySQL version" may occur
  
 === Cause === === Cause ===
  
-As we know our tool makes data import using the mysql.exe utility and tries to load data from file that was generated by the tool on the same machine where you run the conversion. And if you are running the migration process on the machine that is not the same machine where your MySQL server is running, it means that you tries to make data load from file located on client side. And starting from version 8.0.2 MySQL doesn't allow to load data from client side by default. This setting is controlled by MySQL system variable "local-infile", which is set to "OFF" in latest versions:+Ispirer SQLWays Wizard Tool makes data import using mysql.exe utility and loads data from the file, which was generated by the tool on the same machine where you run the conversion. However, if you are running the migration process on the machine different from the one where your MySQL server is running, it means that you're trying to load data from file located on client side. Please, take into account that MySQL versions 8.0.2 and higher don't allow to load data from client side by default. This setting is controlled by MySQL system variable "local-infile", which is set to "OFF" in the latest versions:
 ^  MySQL Version  ^ Default Value  ^  ^  MySQL Version  ^ Default Value  ^ 
 | **>= 8.0.2** | OFF | | **>= 8.0.2** | OFF |
Line 20: Line 20:
 === Solutions === === Solutions ===
  
-So to solve this case we need just set this option to "ON" in MySQL Server. Or the easiest solution - to use option "Enable Local Load" in the SQLWays Wizard tool. This option will add option "local-infile" in the command line that makes data load in MySQL database. +In order to resolve this problem, all you need is to set this option to "ON" in MySQL Server. Otherwise, you can use an option "Enable Local Load" in the SQLWays Wizard tool. It will add an option "local-infile" in command line that makes data load into MySQL database. 
  
-To do that we need to click "Advanced" button on the "Choose a Target Database" page:+Please, click the "Advanced" button on a"Choose a Target Database" page:
  
 {{:sqlways:troubleshooting-guide:mysql:import:mysql_advanced.png|}} {{:sqlways:troubleshooting-guide:mysql:import:mysql_advanced.png|}}
Line 28: Line 28:
 \\ \\
  
-And then check option "Enable Local Load":+And then check the option "Enable Local Load":
  
 {{:sqlways:troubleshooting-guide:mysql:import:enable_local_load.png|}} {{:sqlways:troubleshooting-guide:mysql:import:enable_local_load.png|}}
  
  
-Please Note+Please, note: 
-If you don't see the "Advanced" button on this page, please switch the tool to the "Expert Mode". On how to do that please refer 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, pleaserefer 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 mail 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.1526469326.txt.gz · Last modified: May 16, 2018, 11:15:26 AM by alexandr.kirpichny
 
© 1999-2018, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement