1Panel-dev / 1Panel-dev/1Panel

[Feature] Can database backup store files according to tables?

Open
#7,691 3 comments 0 reactions 1 assignee View on GitHub

@wanghe-fit2cloud is already working on this.

Since Jan 10, 2025.

type: feature-request
Dominant language
Go
Stars
37k
Forks
3.4k
Avg merge
9h 16m
Merged PRs (30d)
105

Description

1Panel Version

v1.10.22-lts

Please describe your needs or suggestions for improvements

背景 我某个库中有几个表特别大 导致整体备份文件就大
有些时候同事手抖 把某条数据给删了 因为关联着好多表 希望我能给恢复一下这几张表的数据

Please describe the solution you suggest

在现有的基础上
备份一个数据库会生成一个压缩包
在压缩包中可否按照每张表一个文件来存储 这样我手动下载下来备份包手动解压 恢复也是很方便的 毕竟1个多G的文件读取下载都很费劲
db_xx.sql.gz
表1.sql
表2.sql
表3.sql
如果希望做的更好一些可以db_xx.sql.gz 改成文件夹 这样恢复的时候从oss中下载的话就下载一部分 而不是全部了
是否可以加上忽略那几张表的备份 有些时候的logs表没有价值 还很大备份的时候还备份了

Additional Information

No response

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.