Can you backup and replace Full Text Search database to speed up reindexing process?

calibrejunkie · 09-09-2023, 11:31 AM

Hello,

So of course, full text search is an amazing addition to calibre.

So my library is very large which means I have a ridiculously large full text search database which takes ages to regenerate if needed, and I was wondering hypothetically if the following would work?

I have an existing full text search database file in my calibre directory.

I make a backup of this file and store it elsewhere.

Something happens to my live full text database and I need to rebuild the database, but there have been say, 100 items added since the last backup.

I turn off full text search to erase the old corrupt version of the database.

I turn it on briefly so it can index a few books and generate a new full text search database with a few items indexed in it.

I shutdown calibre and overwrite the small index I just generated with the backup copy, then restart calibre again.

Will this new replacement index work, and if it does, will it know to index the missing books since it is out of date from the previous one?

Thanks for reading!

kovidgoyal · 09-09-2023, 11:32 AM

No I'm afraid not, its not a concatenative file. If you know how many new files are present since the replacement you can re-index them manually instead.

calibrejunkie · 09-09-2023, 11:38 AM

Ok thanks for the fast reply! Keeping track of what books are new actually shouldn't be a problem at all. Definitely beats a regeneration from scratch.

Thanks again!

09-09-2023, 11:31 AM	#1
calibrejunkie Page Junkie Dev Posts: 37 Karma: 6280 Join Date: Jul 2018 Location: Earth Device: Android Phone, Kindle, Surface Pro 3	Can you backup and replace Full Text Search database to speed up reindexing process? Hello, So of course, full text search is an amazing addition to calibre. So my library is very large which means I have a ridiculously large full text search database which takes ages to regenerate if needed, and I was wondering hypothetically if the following would work? I have an existing full text search database file in my calibre directory. I make a backup of this file and store it elsewhere. Something happens to my live full text database and I need to rebuild the database, but there have been say, 100 items added since the last backup. I turn off full text search to erase the old corrupt version of the database. I turn it on briefly so it can index a few books and generate a new full text search database with a few items indexed in it. I shutdown calibre and overwrite the small index I just generated with the backup copy, then restart calibre again. Will this new replacement index work, and if it does, will it know to index the missing books since it is out of date from the previous one? Thanks for reading!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Multiple Search/Replace as a batch process	idf560	Library Management	7	05-22-2020 12:30 AM
Can we run Function mode in Search & replace during the conversion process?	omin	Conversion	2	02-08-2020 08:53 PM
Search and replace with marked text	mrmikel	Editor	1	05-01-2014 02:07 PM
Search & replace TEXT	ToeRag	Calibre	3	04-10-2010 01:44 PM
Google Book Search to search full-text books online	Bob Russell	Deals and Resources (No Self-Promotion or Affiliate Links)	1	08-19-2006 12:13 PM

09-09-2023, 11:32 AM	#2
kovidgoyal creator of calibre Posts: 45,345 Karma: 27182818 Join Date: Oct 2006 Location: Mumbai, India Device: Various	No I'm afraid not, its not a concatenative file. If you know how many new files are present since the replacement you can re-index them manually instead.

09-09-2023, 11:38 AM	#3
calibrejunkie Page Junkie Dev Posts: 37 Karma: 6280 Join Date: Jul 2018 Location: Earth Device: Android Phone, Kindle, Surface Pro 3	Ok thanks for the fast reply! Keeping track of what books are new actually shouldn't be a problem at all. Definitely beats a regeneration from scratch. Thanks again!

Advert