Ispirer Website Ispirer Capabilities: MySQL Migration Free Trial

ERROR 3948 (42000) at Line 1: Loading Local Data is Disabled; This Must be Enabled on Both the Client and Server Sides

Symptoms

Loading data into a table during the import to MySQL database can lead to the following message: “ERROR 3948 (42000) at line 1: Loading local data is disabled; this must be enabled on both the client and server sides”.

Cause

  • Local data load option is not set.
  • Loading data into a table is performed with LOCAL_INFILE variable set to OFF

Solutions

NOTE! In order to set the settings below, Expert Mode should be enabled: How to Use SQLWays Wizard in Expert Mode

1. To set local data load into MySQL database, you should switch on the “Import from client” and “Enable local load” options at “Advanced” Page.

2. To set variable LOCAL_INFILE to ON in MySQL database perform the command:

  SET GLOBAL LOCAL_INFILE=TRUE;

For check:

  SHOW GLOBAL VARIABLES LIKE 'LOCAL_INFILE';
  


If you have any other questions, please, feel free to contact our support team: support@ispirer.com