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

[Feature Request]: Infinity database backup and restore function. #1183

Open
JinHai-CN opened this issue May 7, 2024 · 0 comments
Open

[Feature Request]: Infinity database backup and restore function. #1183

JinHai-CN opened this issue May 7, 2024 · 0 comments
Labels
feature request New feature or request

Comments

@JinHai-CN
Copy link
Contributor

JinHai-CN commented May 7, 2024

Describe the feature you'd like

We need tools to backup and restore infinity data to avoid data recovery after fatal data errors.

Describe implementation you've considered

Introduce following command or API to support backup and restore data.

  1. CREATE TABLE SNAPSHOT ON {table_name};
  2. CREATE DATABASE SNAPSHOT ON {database_name};
  3. CREATE FULL SNAPSHOT;
  4. SHOW SNAPSHOTS;
  5. SHOW TABLE SNAPSHOTS;
  6. SHOW DATABASE SNAPSHOTS;
  7. SHOW FULL SNAPSHOTS;
  8. SHOW SNAPSHOT {snapshot_name};
  9. DELETE SNAPSHOTS {snapshot_name};
  10. RECOVER FROM SNAPSHOT {snapshot_name};

Each snapshot means a file which includes all information of the snapshot.

@JinHai-CN JinHai-CN added the feature request New feature or request label May 7, 2024
@JinHai-CN JinHai-CN mentioned this issue May 7, 2024
79 tasks
@JinHai-CN JinHai-CN changed the title [Feature Request]: Infinity database backup and restore tools. [Feature Request]: Infinity database backup and restore funtion. Jul 1, 2024
@JinHai-CN JinHai-CN changed the title [Feature Request]: Infinity database backup and restore funtion. [Feature Request]: Infinity database backup and restore function. Jul 1, 2024
@JinHai-CN JinHai-CN mentioned this issue Dec 19, 2024
25 tasks
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
feature request New feature or request
Projects
None yet
Development

No branches or pull requests

1 participant