TiDB Backup Issues

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

Original topic: tidb 备份问题

| username: Cheriston

What is the problem with my local backup?

| username: TiDBer_vfJBUcxl | Original post link

File or directory does not exist

| username: 啦啦啦啦啦 | Original post link

Each TiKV needs to have a corresponding directory.

| username: Kongdom | Original post link

The error message indicates that there is no directory or file on 157. This requires mounting the directory.

| username: Cheriston | Original post link

I am backing up on 156, do I also need to do it on 157?

| username: Kongdom | Original post link

Yes, I’ll look for the documentation.

| username: Kongdom | Original post link

It is recommended to do mounting, the simplest, whether for backup or recovery.

| username: 大飞哥online | Original post link

You are doing a full backup, and TiKV is performing the backup. Each machine needs to have the corresponding directory.

| username: Cheriston | Original post link

No, it doesn’t work. All three nodes have created directories.

Backup still doesn’t work.

| username: Kongdom | Original post link

Show me the backup statement.

| username: zhanggame1 | Original post link

All TiKV instances must be able to access the backup path you specified. Mounting an NFS would be much more convenient.

| username: zhanggame1 | Original post link

The backup path you posted in the main thread is “back” instead of “backup.” Check if you created the wrong directory.

| username: tidb菜鸟一只 | Original post link

Create a /back directory on each TiKV node and assign permissions.

| username: 摊煎饼果子的蒙其 | Original post link

The image is not available for translation. Please provide the text content directly.

| username: Kongdom | Original post link

Yes, so let’s wait for him to send the backup statement and take a look. It seems like the issue is here.

| username: TiDBer_vfJBUcxl | Original post link

The backup statement is below the first picture of the backup statement.

| username: TiDBer_vfJBUcxl | Original post link

The issue with the backup path,
it is written as “local:///back”, it should be “local:///backup”.

| username: Kongdom | Original post link

Okay, has the backup been successful now?
Remember to mark the best answer :wink:

| username: TiDBer_vfJBUcxl | Original post link

I’m not the one who posted, so I don’t know if it has been resolved.

| username: Kongdom | Original post link

:joy: :joy: :joy: I misread it.