lost custom columns after database restor

TiboFA · 05-31-2023, 01:06 PM

Hello,
after having several issues with my database, I decided to start a database restore. everything went well, but I lost all custom columns I had...
when I check the opf file content, it seems it's ok.
Is there a way to restore a database with the custom columns ?
Or a solution to recreate those columns and get the values for each book ?
thanks for you help

theducks · 05-31-2023, 01:28 PM

How did you do the Restore?
If you used Add Books, I hope you had a backup of the Library because the old OPF files are now 'new' and missing all the other data

Restore Database Uses the OPF file IN the Library as well as
metadata_db_prefs_backup.json to restore the structure of the DB

TiboFA · 06-01-2023, 12:09 AM

thank you for the quick answer and the important point

I did a "normal" restore, but maybe the json file was corrupted.
I start a new database restoration with an old version of the json file... let's see

TiboFA · 06-01-2023, 03:36 PM

I did it, and it worked
than you for your help

05-31-2023, 01:06 PM	#1
TiboFA Junior Member Posts: 3 Karma: 10 Join Date: May 2023 Device: none	lost custom columns after database restor Hello, after having several issues with my database, I decided to start a database restore. everything went well, but I lost all custom columns I had... when I check the opf file content, it seems it's ok. Is there a way to restore a database with the custom columns ? Or a solution to recreate those columns and get the values for each book ? thanks for you help

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Ratings Custom Columns Created From other Columns	Tanjamuse	Library Management	4	09-28-2020 12:57 AM
lost my custom columns while changing computers	cigale	Library Management	5	09-21-2020 08:59 PM
Lost custom columns in metadata editor	maddz	Calibre	1	04-05-2020 04:10 PM
Help Needed for Custom Columns Created From other Columns	Tanjamuse	Library Management	5	09-02-2018 06:19 PM
lost my books database with personalized columns	Misachat	Library Management	13	02-11-2017 04:33 AM

05-31-2023, 01:28 PM	#2
theducks Well trained by Cats Posts: 31,048 Karma: 60358908 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	How did you do the Restore? If you used Add Books, I hope you had a backup of the Library because the old OPF files are now 'new' and missing all the other data Restore Database Uses the OPF file IN the Library as well as metadata_db_prefs_backup.json to restore the structure of the DB

06-01-2023, 12:09 AM	#3
TiboFA Junior Member Posts: 3 Karma: 10 Join Date: May 2023 Device: none	thank you for the quick answer and the important point I did a "normal" restore, but maybe the json file was corrupted. I start a new database restoration with an old version of the json file... let's see

06-01-2023, 03:36 PM	#4
TiboFA Junior Member Posts: 3 Karma: 10 Join Date: May 2023 Device: none	I did it, and it worked than you for your help

Advert