0

I have a large fts5 virtual table (currently about 90GB).

Because the sqlite ODBC driver, which I use (version 3.43.2) as my main sqlite scripting client, doesn't support fts5, I populate and use fts5 either via sqlitespy (1.9.16) or via sqlite-utils (3.38). This setup is OK, if not ideal, for day-to-day purposes.

However neither sqlitespy nor sqlite-utils gives me any realistic backup options. I would normally clone a database and/or dump the tables, but I can find no way of doing either of these, and am reduced to doing a file copy. I can't find any references anywhere on the web to fts5 backups, so I don't even know if .dump would work against a fts5 virtual table.

Does anyone have a fts5 backup solution, and/or can anyone suggest a Windows 11 64 bit client that supports fts5, .clone, and (if relevant) .dump that I can use instead of the ODBC driver? (I can't find one of those on the web either.) I am not realistically in a position to compile my own sqlite client with fts5 enabled.

Improve this question
0
Related questions
3
Populate virtual SQLite FTS5 (full text search) table from content table
0
MySQL to Sqlite sync from PHP to mobile app (iOS/Android)
0
how to delete items hitting TotalBackupBilled metric for RDS
Load 6 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.