import mysql dump to PXC

[Harery]

[root@nd1 ~]# mysql -u root -p new_test < Dump20180101.sql
Enter password:
ERROR 1105 (HY000) at line 39: Percona-XtraDB-Cluster prohibits use of LOCK TABLE/FLUSH TABLE WITH READ LOCK with pxc_strict_mode = ENFORCING

can any one help me why i cant import it to my PXC and how i can solve it ?

[lorraine.pocklington]

Hi, did you see this discussion: https://www.percona.com/forums/questions-discussions/percona-xtradb-cluster/47099-migrate-mysql-master-slave-to-percona-xtradb-cluster
This leads to this page in the documentation https://www.percona.com/doc/percona-xtradb-cluster/5.7/features/pxc-strict-mode.html

If you’ve already checked those out, please update with additional information e.g. version, environment, any other messages appearing in logs etc. so that the team have the best chance to help you out.

[Harery]

i solved this issue by
set global pxc_strict_mode=DISABLED ;

[Dirk23]

@Harery;51394

i solved this issue by
set global pxc_strict_mode=DISABLED ;

Did you just disable strict mode for the import and enabled it again after the import was done?