Issues Related to Restoring System Tables

Translated
1

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: br 恢复系统表相关问题

| username: Raymond

The official documentation says that BR cannot restore system tables, but I tested it today and found that the data in the mysql.user table can be restored. What’s going on?

  1. Created 2 users, which can be seen in the mysql.user table.
  2. Full backup with BR.
  3. Restored with BR and found that these 2 users can still be seen in the mysql.user table.
2
| username: xfworld | Original post link

In a test environment, you can do whatever you want, but if something goes wrong in production, what will you do…

3
| username: cs58_dba | Original post link

This thing is related to permissions, I suggest re-adding the user.

4
| username: fubinzh | Original post link

Which version are you using? What is the restore command, and did you explicitly specify restoring the system table?