# Error message when restoring percona xtraDB cluster 8.0.19 **URL:** \ **Category:** Percona XtraDB Cluster 8.x\ **Tags:** community, mysql, percona\ **Created:** [August 12, 2020, 6:11am UTC](https://forums.percona.com/t/error-message-when-restoring-percona-xtradb-cluster-8-0-19/7892 "2020-08-12T06:11:38Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![DBA100](https://avatars.discourse-cdn.com/v4/letter/d/b3f665/32.png) [@DBA100](https://forums.percona.com/u/DBA100)\ **Post date:** [August 12, 2020, 6:11am UTC](https://forums.percona.com/t/error-message-when-restoring-percona-xtradb-cluster-8-0-19/7892/1 "2020-08-12T06:11:38Z")
hi, 1) Today when restoring one of the DB by mysqldump, it said: ERROR 1231 (42000) at line 1222: Variable ‘sql\_mode’ can’t be set to the value of ‘NO\_AUTO\_CREATE\_USER’ this DB I restore do not have trigger restored, is it a hints. what should I do to make it restoreable ? 2) our percona xtgraDB Cluster 8.0.19 has a DB called mysql, it is a system default DB and what is it for ? ---
**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\ **Post date:** [August 12, 2020, 11:49am UTC](https://forums.percona.com/t/error-message-when-restoring-percona-xtradb-cluster-8-0-19/7892/2 "2020-08-12T11:49:56Z")
1. The SQL mode  **NO\_AUTO\_CREATE\_USER**  was removed in MySQL 8.0. If you are trying to restore a mysqldump from 5.7 to 8.0, this is probably why it is failing. You can find this line in your dump and simply remove it, or use the ‘–force’ option when doing the restore to skip over errors. 2. The “mysql” database contains system information in addition to user, permissions, etc. ---
**Author:** ![DBA100](https://avatars.discourse-cdn.com/v4/letter/d/b3f665/32.png) [@DBA100](https://forums.percona.com/u/DBA100)\ **Post date:** [August 13, 2020, 4:07am UTC](https://forums.percona.com/t/error-message-when-restoring-percona-xtradb-cluster-8-0-19/7892/3 "2020-08-13T04:07:49Z")
“or use the ‘–force’ option when doing the restore to skip over errors.” I am sorry , how ? **mysql --host=\ -u root -p ** –force **\< \?** **“2. The “mysql” database contains system information in addition to user, permissions, etc.”** **so we don’t need to restore this one in mysql 5.7 and 8.0.19 ?** ---
**Author:** ![DBA100](https://avatars.discourse-cdn.com/v4/letter/d/b3f665/32.png) [@DBA100](https://forums.percona.com/u/DBA100)\ **Post date:** [August 13, 2020, 6:25am UTC](https://forums.percona.com/t/error-message-when-restoring-percona-xtradb-cluster-8-0-19/7892/4 "2020-08-13T06:25:10Z")
"‘–force’ " is not working for me and my command is:  mysql -u root -p --force  \< UAT\_DB\_\_bak.sql ---
**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\ **Post date:** [August 13, 2020, 1:00pm UTC](https://forums.percona.com/t/error-message-when-restoring-percona-xtradb-cluster-8-0-19/7892/5 "2020-08-13T13:00:24Z")
I can’t help if you don’t provide the full output. What do you mean “is not working”? ---
**Author:** ![DBA100](https://avatars.discourse-cdn.com/v4/letter/d/b3f665/32.png) [@DBA100](https://forums.percona.com/u/DBA100)\ **Post date:** [August 14, 2020, 12:08am UTC](https://forums.percona.com/t/error-message-when-restoring-percona-xtradb-cluster-8-0-19/7892/6 "2020-08-14T00:08:02Z")
same error message ! so the --force can’t help on this situtation. ---
**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\ **Post date:** [August 14, 2020, 7:56am UTC](https://forums.percona.com/t/error-message-when-restoring-percona-xtradb-cluster-8-0-19/7892/7 "2020-08-14T07:56:10Z")
Then you need to edit your dump file, find the line that contains sql\_mode and remove it. ---
**Author:** ![DBA100](https://avatars.discourse-cdn.com/v4/letter/d/b3f665/32.png) [@DBA100](https://forums.percona.com/u/DBA100)\ **Post date:** [August 28, 2020, 1:57am UTC](https://forums.percona.com/t/error-message-when-restoring-percona-xtradb-cluster-8-0-19/7892/8 "2020-08-28T01:57:45Z")
it seems I need to remove  NO\_AUTO\_CREATE\_USER, tks. it only involve when the restore is restoring mysql logic. ---
**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\ **Post date:** [August 28, 2020, 8:52am UTC](https://forums.percona.com/t/error-message-when-restoring-percona-xtradb-cluster-8-0-19/7892/9 "2020-08-28T08:52:46Z")
NO\_AUTO\_CREATE\_USER is a security feature that was introduced in 5.7 but only in 8.0 was enabled by default. If you use a tool like pt-show-grants, this issue is automatically handled for you.