Please make it possible to only dump database #2519

Closed
opened 2025-11-02 04:39:12 -06:00 by GiteaMirror · 2 comments
Owner

Originally created by @brueggemannapollo on GitHub (Nov 12, 2018).

  • Gitea version (or commit ref): 1.6
  • Git version: 2.16.4
  • Operating system: SLES15
  • Database (use [x]):
    • PostgreSQL
    • MySQL
    • MSSQL
    • SQLite
  • Can you reproduce the bug at https://try.gitea.io:
    • Yes (provide example URL)
    • No
    • Not relevant
  • Log gist:

Description

Please make it possible to only dump database. We like to migrate to another database backend and I tried to dump the database in new sql syntax, but we have the problem that our git repositories are using >100G diskspace. This needs hours to be zipped but we only need the sql export.

Originally created by @brueggemannapollo on GitHub (Nov 12, 2018). - Gitea version (or commit ref): 1.6 - Git version: 2.16.4 - Operating system: SLES15 - Database (use `[x]`): - [ ] PostgreSQL - [X] MySQL - [ ] MSSQL - [ ] SQLite - Can you reproduce the bug at https://try.gitea.io: - [ ] Yes (provide example URL) - [ ] No - [X] Not relevant - Log gist: ## Description Please make it possible to only dump database. We like to migrate to another database backend and I tried to dump the database in new sql syntax, but we have the problem that our git repositories are using >100G diskspace. This needs hours to be zipped but we only need the sql export.
GiteaMirror added the type/proposalreviewed/wontfix labels 2025-11-02 04:39:12 -06:00
Author
Owner

@SagePtr commented on GitHub (Nov 12, 2018):

Why not to do it with any SQL backup stuff? For mysql:
mysqldump -u username -ppassword dbname > file.sql

@SagePtr commented on GitHub (Nov 12, 2018): Why not to do it with any SQL backup stuff? For mysql: mysqldump -u **username** -p**password** **dbname** > file.sql
Author
Owner

@lafriks commented on GitHub (Nov 12, 2018):

As suggested for database only backups use database dedicated tools (MySQL -> mysql, PostgreSQL -> psql, sqlite -> backup db file)

@lafriks commented on GitHub (Nov 12, 2018): As suggested for database only backups use database dedicated tools (MySQL -> mysql, PostgreSQL -> psql, sqlite -> backup db file)
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/gitea#2519