failing Replication from Sqlserver to MYsql

[Denial]

Hi ,

We are getting below error  while replicating data from sqlserver to my sql 

error :-

Handling End of table 'collage'.'Employee' loading failed by subtask 1 thread 1
Failed to load data from csv file.
Failed to load file '1'
Failed to start load process for file '1'
RetCode: SQL_ERROR SqlState: HY000 NativeError: 3948 Message: [MySQL][ODBC 8.0(w) Driver][mysqld-8.0.32]Loading local data is disabled; this must be enabled on both the client and server sides
Failed (retcode -1) to execute statement: 'load data local infile "C:\\Program Files\\Attunity\\Replicate\\data\\tasks\\test1\\data_files\\1\\LOAD00000001.csv" into table `collage`.`Employee` CHARACTER SET UTF8MB4 fields terminated by ',' enclosed by '"' lines terminated by '\n'( `EmployeeID`,`FirstName` )

Please let us know the solution .

Thanks,

[john_wang · Accepted solution]

Hello @Denial ,

Thanks for reaching out!

If you are running Full Load, or CDC with Batch Apply Mode then load method is called , the local_infile is required by MySQL Server. You can set it in MySQL setting file (need restart the MySQL service), or set it dynamically (the setting will lost if MySQL Service restart):

mysql> show global variables like 'local_infile';

+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| local_infile | OFF |
+---------------+-------+
1 row in set (0.00 sec)
mysql> set global local_infile = 'ON';

Hope this helps.

Regards,

John.

[Denial]

Hi John,

Thank you it is working 

Thanks,

[john_wang]

Glad to hear that, @Denial .

Please click "Accept as Solution" if possible.