# Import mysql dump to PXC

**URL:** <https://forums.percona.com/t/import-mysql-dump-to-pxc/6104>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [January 6, 2018, 2:28pm UTC](https://forums.percona.com/t/import-mysql-dump-to-pxc/6104 "2018-01-06T14:28:23Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Harery](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/harery/32/1203_2.png) [@Harery](https://forums.percona.com/u/Harery)\
**Post date:** [January 6, 2018, 2:28pm UTC](https://forums.percona.com/t/import-mysql-dump-to-pxc/6104/1 "2018-01-06T14:28:23Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![lorraine.pocklington](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/lorraine.pocklington/32/37_2.png) [@lorraine.pocklington](https://forums.percona.com/u/lorraine.pocklington)\
**Post date:** [January 8, 2018, 10:54am UTC](https://forums.percona.com/t/import-mysql-dump-to-pxc/6104/2 "2018-01-08T10:54:11Z")

</div>

Hi, did you see this discussion: [Migrate MySQL Master-Slave to Percona XtraDB Cluster](https://forums.percona.com/t/migrate-mysql-master-slave-to-percona-xtradb-cluster/5386)

This leads to this page in the documentation [PXC Strict Mode - Percona XtraDB Cluster](https://docs.percona.com/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.

---

<div class="post-metadata">

**Author:** ![Harery](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/harery/32/1203_2.png) [@Harery](https://forums.percona.com/u/Harery)\
**Post date:** [April 30, 2018, 9:44am UTC](https://forums.percona.com/t/import-mysql-dump-to-pxc/6104/3 "2018-04-30T09:44:01Z")

</div>

i solved this issue by  
set global pxc\_strict\_mode=DISABLED ;

---

<div class="post-metadata">

**Author:** ![Dirk23](https://avatars.discourse-cdn.com/v4/letter/d/fbc32d/32.png) [@Dirk23](https://forums.percona.com/u/Dirk23)\
**Post date:** [May 7, 2018, 3:05am UTC](https://forums.percona.com/t/import-mysql-dump-to-pxc/6104/4 "2018-05-07T03:05:18Z")

</div>

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