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.

Sign up for GitHub

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

Jump to bottom

Import/Export Database #2312

Closed
ray6080 opened this issue Oct 31, 2023 · 1 comment
Closed

Import/Export Database #2312

ray6080 opened this issue Oct 31, 2023 · 1 comment
Assignees
@acquamarin @hououou
Labels
feature New features or missing components of existing features good-warm-up Good warm up feature high-priority usability Issues related to better usability experience, including bad error messages

Comments

@ray6080
Copy link
Contributor

ray6080 commented Oct 31, 2023

The motivation of this feature is to enable easier data migration between kuzu databases with different storage versions.
The Export Database statement can export all tables plus their schema definition and copy statements to a specified directory, and Import Database can read from there and load all tables again.

Basic syntax:

EXPORT DATABASE 'output_directory';
IMPORT DATABASE 'output_directory';

Options to provide:

  • Data format: CSV, Parquet
  • Supported copy to options for CSV and Parquet
@ray6080 ray6080 added the feature New features or missing components of existing features label Oct 31, 2023
@ray6080 ray6080 mentioned this issue Oct 31, 2023
Closed
17 tasks
@ray6080 ray6080 added the good-warm-up Good warm up feature label Dec 31, 2023
@semihsalihoglu-uw semihsalihoglu-uw added the usability Issues related to better usability experience, including bad error messages label Jan 8, 2024
@andyfengHKU
Copy link
Contributor

I'm closing this issue because most part of it has been done. The leftover work are tracked in #3280

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@acquamarin acquamarin

@hououou hououou

Labels
feature New features or missing components of existing features good-warm-up Good warm up feature high-priority usability Issues related to better usability experience, including bad error messages
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
5 participants
@ray6080 @andyfengHKU @semihsalihoglu-uw @acquamarin @hououou