gitea dump causes database query_timeout exceeded

[FlyingOnion]

Description

Database: mysql
Num of users: about 470k

Run gitea dump.

2022/05/19 14:36:18 cmd/dump.go:150:fatal() [F] Failed to dump database: Error 1907: Query execution was interrupted, query_timeout exceeded

The last row of dumped gitea-db is an INSERT INTO user statement.

Gitea Version

1.15.5

Can you reproduce the bug on the Gitea demo site?

No

Log Gist

No response

Screenshots

No response

Git Version

No response

Operating System

No response

How are you running Gitea?

Helm chart

Database

MySQL

[wxiaoguang]

A little off-topic: I think the gitea dump isn't designed for large git site, indeed there are various problems when using the gitea dump (some are already reported in the issue list ....)

If you are running a large git site, you should have your own DevOps methods for backups ....

[supermangithu]

A little off-topic: I think the gitea dump isn't designed for large git site, indeed there are various problems when using the gitea dump (some are already reported in the issue list ....)

If you are running a large git site, you should have your own DevOps methods for backups ....

This is what i mentioned before for gitea dump export about 100GB files is slow and not safe.I suggest gitea own three kinds of backup modes before.Gitea is all right for do the git version archive with small memory.On the contray, Gitlab CE need the high memory.
It need main developer and fundamental developer make a meeting to discuss and decide @lunny
and main developer paticipant @wxiaoguang .
Thanks in advance!
Look at these:

• [Question] Does gitea dump protect against data corruption when backing up live repos? #19640
• Gitea incremental backup #19593
• Suggest adding a backup mode #19084
• [Question] Does gitea dump protect against data corruption when backing up live repos? #19640
• Can the repository name support UTF-8 names? i.e. Chinese #19699

all about gitea dump ,transfer big sql database (backup mode)

[lunny]

470K? There are really so many users? Is that a production system?

[supermangithu]

470K? There are really so many users? Is that a production system?

Glad to see you reply @lunny .
Suggestion:
the following link is similar to what i mentioned. He is migrating gitea repo to gitea repo #19533 ,my qusetion #19593 use giea dump to export and transfer code to another gitea instance.Gitea dump export function need more stability.
Thanks in advance!

[lunny]

I think you could do that with some other tools like rsync and some database hot back up tools yourselves. We should update the documentation about which content should be back up.

[FlyingOnion]

Then what about adding a --skip-database flag to gitea dump ?