Buy Percona ServicesBuy Now!

import mysql dump to PXC

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • import mysql dump to PXC

    [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 <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: https://www.percona.com/forums/quest...xtradb-cluster
    This leads to this page in the documentation https://www.percona.com/doc/percona-...rict-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.

    Comment


    • #3
      i solved this issue by
      set global pxc_strict_mode=DISABLED ;

      Comment


      • #4
        Originally posted by Harery View Post
        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?

        Comment

        Working...
        X