Import mysql dump to PXC

MySQL & MariaDB Percona XtraDB Cluster 5.x
1

[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 ?

2

Hi, did you see this discussion: Migrate MySQL Master-Slave to Percona XtraDB Cluster

This leads to this page in the documentation PXC Strict Mode - Percona XtraDB Cluster

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.

3

i solved this issue by
set global pxc_strict_mode=DISABLED ;

2 Likes
4

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