Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Data dump #422

Closed
muety opened this issue Oct 28, 2022 · 2 comments
Closed

Data dump #422

muety opened this issue Oct 28, 2022 · 2 comments
Assignees
Labels
effort:4 enhancement New feature or request prio a

Comments

@muety
Copy link
Owner

muety commented Oct 28, 2022

Option for users to download a big, fat dump (probably zipped CSVs) of all their data to easily migrate from one instance to another, e.g. from Wakapi.dev to self-hosted or vice versa.

Still undecided, if we want restore functionality as well (i.e. upload and import the dump again) or if it would be sufficient to add precise documentation on how to import these dumps directly to the database.

Potentially relates to #321, #323.

@muety muety added enhancement New feature or request prio a effort:4 labels Oct 28, 2022
@muety muety self-assigned this Oct 28, 2022
@muety
Copy link
Owner Author

muety commented Nov 5, 2022

MySQL: https://dev.mysql.com/doc/refman/8.0/en/select-into.html

Postgres: https://www.postgresql.org/docs/current/sql-copy.html

SQLite: Looks like there is no way to directly dump a query into a file without using the CLI

@muety
Copy link
Owner Author

muety commented Nov 17, 2022

Decided to use Wakapi's already existing import functionality for this.

@muety muety closed this as completed Nov 17, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
effort:4 enhancement New feature or request prio a
Projects
None yet
Development

No branches or pull requests

1 participant