Redesign backup & restore tool for disaster recovery

[killme2008]

What type of enhancement is this?

API improvement

What does the enhancement do?

We already have backup & restore tools to backup and restore the database when something goes bad.

But it's not easy to use. You must use the COPY SQL and greptime cli together.

https://docs.greptime.com/user-guide/administration/disaster-recovery/back-up-&-restore-data

https://docs.greptime.com/user-guide/upgrade#cli

The steps are cumbersome and not user-friendly.

It's better to redesign it for DR, including:

• One tool to get all things done.
• Increment backup both of schema and data.
• Restore from schema and data.

Implementation challenges

No response

[fengjiachun]

Tasks

• Export database data in a time range(Incremental Backup) feat: export database data #4382
• Import schema and data with cli tool. feat: import cli tool #4639
• show create database feat: show create database #4642
• export and import create database sql feat: export import database #4654
• One tool to get all things done.