Backup and Restore of RT index

General Discussions - English
1

Hi
Is it possible to take backup & restore of RT index .

2

currently you need to stop daemon and copy folder with RT index or whole data folder (in case of config-less mode)

3

what if the the RT index or table is dropped,is it possible to recover and restore…?

4

no, these statements CREATE TABLE \ DROP TABLE \ ALTER TABLE are not recoverable

5

is it possible to restore with the data folder (RT indexes)…?

6

yes you can stop daemon buckup data folder then restore it again with daemon stopped

7

Can the newish ‘import table’ function maybe used for backups? It in effect duplicating an index.

Could perhaps ‘import’ the active RT index, into a new index (either in same daemon, or a second daemon)?

A restore would be dropping the index and importing it again from the backup index.

I guess the problem is the import can’t copy the RAM-Chunk of the index. But can be maybe mitigated by calling (in the original daemon) FLUSH RTINDEX?

Maybe not particularly useful, but could also ‘backup’ jsut the schema with CREATE TABLE … LIKE …