1Panel-dev / 1Panel-dev/1Panel
[Feature] Can database backup store files according to tables?
Open
@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
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Assessment
This issue has not been assessed yet.