github-starred/gitea
2
0
Fork 0
mirror of https://github.com/go-gitea/gitea.git synced 2026-03-13 02:57:44 -05:00
Code Issues 2.6k Packages Projects Releases 100 Wiki Activity

How to migrate from sqlite3 to mysql？ #7048

New Issue
Closed
opened 2025-11-02 07:14:23 -06:00 by GiteaMirror · 3 comments
GiteaMirror commented 2025-11-02 07:14:23 -06:00
Owner
Copy Link

Originally created by @li-xunhuan on GitHub (Mar 22, 2021).

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

Description

I want to upgrade from 1.12.5 to 1.13.x, but after updating the binary file, the CPU occupies 100% and cannot be used. I want to migrate to MySQL, but the database table fields seem to be different

Screenshots

Originally created by @li-xunhuan on GitHub (Mar 22, 2021). <!-- NOTE: If your issue is a security concern, please send an email to security@gitea.io instead of opening a public issue --> <!-- 1. Please speak English, this is the language all maintainers can speak and write. 2. Please ask questions or configuration/deploy problems on our Discord server (https://discord.gg/gitea) or forum (https://discourse.gitea.io). 3. Please take a moment to check that your issue doesn't already exist. 4. Make sure it's not mentioned in the FAQ (https://docs.gitea.io/en-us/faq) 5. Please give all relevant information below for bug reports, because incomplete details will be handled as an invalid report. --> - Gitea version (or commit ref): `1.12.5` - Git version: - Operating system: <!-- Please include information on whether you built gitea yourself, used one of our downloads or are using some other package --> <!-- Please also tell us how you are running gitea, e.g. if it is being run from docker, a command-line, systemd etc. ---> <!-- If you are using a package or systemd tell us what distribution you are using --> - Database (use `[x]`): - [ ] PostgreSQL - [ ] MySQL - [ ] MSSQL - [ ] SQLite - Can you reproduce the bug at https://try.gitea.io: - [ ] Yes (provide example URL) - [ ] No - Log gist: <!-- It really is important to provide pertinent logs --> <!-- Please read https://docs.gitea.io/en-us/logging-configuration/#debugging-problems --> <!-- In addition, if your problem relates to git commands set `RUN_MODE=dev` at the top of app.ini --> ## Description <!-- If using a proxy or a CDN (e.g. CloudFlare) in front of gitea, please disable the proxy/CDN fully and connect to gitea directly to confirm the issue still persists without those services. --> I want to upgrade from 1.12.5 to 1.13.x, but after updating the binary file, the CPU occupies 100% and cannot be used. I want to migrate to MySQL, but the database table fields seem to be different ## Screenshots <!-- **If this issue involves the Web Interface, please include a screenshot** -->
GiteaMirror added the type/question label 2025-11-02 07:14:23 -06:00
GiteaMirror commented 2025-11-02 07:14:24 -06:00
Author
Owner
Copy Link

@somera commented on GitHub (Mar 22, 2021):

Manually or jou can use the rest api with own script.

@somera commented on GitHub (Mar 22, 2021): Manually or jou can use the rest api with own script.
GiteaMirror commented 2025-11-02 07:14:25 -06:00
Author
Owner
Copy Link

@somera commented on GitHub (Mar 22, 2021):

https://gitlab.com/markuman/gitea-mariadb-migration/

@somera commented on GitHub (Mar 22, 2021): https://gitlab.com/markuman/gitea-mariadb-migration/
GiteaMirror commented 2025-11-02 07:14:25 -06:00
Author
Owner
Copy Link

@somera commented on GitHub (Mar 22, 2021):

https://github.com/go-gitea/gitea/issues/12909

@somera commented on GitHub (Mar 22, 2021): https://github.com/go-gitea/gitea/issues/12909
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
$20
$250
$50
$500
backport/done
💎 Bounty
docs-update-needed
good first issue
hacktoberfest
issue/bounty
issue/confirmed
issue/critical
issue/duplicate
issue/needs-feedback
issue/not-a-bug
issue/regression
issue/stale
issue/workaround
lgtm/need 2
modifies/api
modifies/translation
outdated/backport/v1.18
outdated/theme/markdown
outdated/theme/timetracker
performance/bigrepo
performance/cpu
performance/memory
performance/speed
pr/breaking
proposal/accepted
proposal/rejected
pr/wip
pull-request
Mirrored from GitHub Pull Request
 reviewed/wontfix
💰 Rewarded
skip-changelog
status/blocked
topic/accessibility
topic/api
topic/authentication
topic/build
topic/code-linting
topic/commit-signing
topic/content-rendering
topic/deployment
topic/distribution
topic/federation
topic/gitea-actions
topic/issues
topic/lfs
topic/mobile
topic/moderation
topic/packages
topic/pr
topic/projects
topic/repo
topic/repo-migration
topic/security
topic/theme
topic/ui
topic/ui-interaction
topic/ux
topic/webhooks
topic/wiki
type/bug
type/deprecation
type/docs
type/enhancement
type/feature
type/miscellaneous
type/proposal
type/question
type/refactoring
type/summary
type/testing
type/upstream
No Label type/question
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
GiteaMirror ninjasurge
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/gitea#7048
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?