Option to backup and restore pools

[SoftTools59654]

Option to backup and restore pools

Currently, in order to transfer a pool, in case of changing windows or installing the zui program in the new system, we must take an output in the form of vng or zng and restore it, because these two extensions are imported much faster than other files.

If there is an option that can back up all pools and queries in one place and restore it when needed, it will be a good option.

Importing volume data, especially in csv and json, takes time. I think the backup option is faster even than re-importing vng and zng

[philrz]

@SoftTools59654: Thanks for highlighting this. Yes, we agree that it would be good at some point to have a single push-button option in Zui to backup/restore all the pools+queries (and perhaps other "user data" as well, e.g., contents of History, current configurable Settings, etc.) in a single operation. As we probably won't get to this right away, a couple things that could help achieve the functionality equivalent with what's already in Zui:

1. All the pool data is present below the lake subdirectory below Zui's User data path. At the OS level you could use ZIP/tar to bundle up this lake subdirectory and then unpack it in place of the lake subdirectory of a fresh Zui install and you'll start out with all the same pool data.

2. A set of queries can be backed up if they're in a query folder, e.g., such as shown in this screenshot with the Brimcap queries. What's at that link also describes how to import into another Zui from such an exported set. We know this is an under-documented part of Zui right now and have an open issue Feature Tour video: Query Library #2903 to track addressing this.

I'll hold this issue open as a reminder for us to eventually get to the single push-button operation.

[SoftTools59654]

Thank

In the first case, yes, I also use this method

But there is always a problem. It's not a standard practice when I have a dataset I need to backup the whole folder every time for each one
AppData\Roaming\Zui - Insiders\lake
What I do is take a vng and zng output from the entire data and restore this file if needed. It is faster than importing csv and json files.

2 Regarding the second method, yes, I do exactly the same thing

But there is one thing, as long as the query is not inside the folder, it is not possible to export
Of course, this is not a problem either

In general, I think having a standard export and import for this good program is needed.