IntellectualSites / IntellectualSites/PlotSquared
Can't import storage.db to mysql
Nobody has claimed this yet.
- Dominant language
- Java
- Stars
- 653
- Forks
- 975
- Avg merge
- 2m
- Merged PRs (30d)
- 6
Description
Server Implementation
Paper
Server Version
1.20.1
Describe the bug
I was trying to migrate old sqlite db to mysql but when i type /plots database import storage.db, database seems to be imported. But not saved to mysql, after reboot data is gone.
To Reproduce
- Enable mysql database in configuration
- import old database with: /plots database import storage.db
- reboot server
- see that data is not saved to mysql db
Expected behaviour
Data saved to mysql when i import it
Screenshots / Videos
No response
Error log (if applicable)
No response
Plot Debugpaste
https://athion.net/ISPaster/paste/view/70879bcda7b64089b6b837b673ad68be
PlotSquared Version
7.0.0-rc.2
Checklist
- I have included a Plot debugpaste.
- I am using the newest build from https://www.spigotmc.org/resources/77506/ and the issue still persists.
Anything else?
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.
Research direction
Start with the /plots database import storage.db command and the MySQL database configuration, then compare the import path with the normal persistence path. Reproduce the migration from SQLite to MySQL and reboot the Paper server. Done means imported data remains available after reboot and is present in MySQL.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java, mysql, sqlite
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100