[Tech Request]: dump a table snapshot and apply the snapshot to a new database

### Is there an existing issue for the same tech request?

- [x] I have checked the existing issues.

### Does this tech request not affect user experience?

- [x] This tech request doesn't affect user experience.

### What would you like to be added ?

```Markdown
Dump a table snapshot and apply the snapshot to a new database
```

### Why is this needed ?

1. For debugging.
2. For better restoration from a snapshot

### Additional information

_No response_