How to migrate Content Server with user annotations?

georgehuang · 03-01-2021, 07:06 AM

I have been using Content Server with authentication enabled on my local machine and had read several books with annotations made along the way. It works great and now I decided to move my library to a VPS (Ubuntu running on Amazon Lightsail, to be specific).

I successfully set up a new Content Server with an new Calibre library, and I can now import my books into it. However, annotations I made on the local machine do not show (it is expected) since the library and its authentication are both new.

The question I have is: what is the right way to migrate my library to the new Content Server? And how do I access my old highlights and notes made on the books?

kovidgoyal · 03-01-2021, 07:54 AM

The annotations are stored in metadata.db simply copy over your library foder to the server.

georgehuang · 03-01-2021, 09:22 AM

Quote:

Originally Posted by kovidgoyal

The annotations are stored in metadata.db simply copy over your library foder to the server.

OK, should have done that instead of copying just one book for test. Just copied the whole folder to the remote server, and the annotations show! Thanks!

However, some books showed an error saying:

Code:

Could not download book
Could not open {Book Name}. Failed to download some book data, click "Show details" for more information

When clicked "Show details", there is a list of files saying something like:

Code:

OEBPS/Styles/Copyrightpage.css
Failed to communicate with "/book-file/474/EPUB/957061/16146072090/OEBPS/Styles%2FCopyrightpage.css?library_id=Calibre&1614608088628", with status: [400 (error)] Bad Request

The uri in the Request Line and the Authorization header do not match

Those books work fine on my local server and ebook-viewer. Is this a problem with my server?

georgehuang · 03-01-2021, 09:37 AM

Just saw this thread: Viewer problem running behind Apache

And yes I am also running Viewer with Apache. Guess this is the problem. I might have to try nginx instead.

03-01-2021, 07:06 AM	#1
georgehuang Enthusiast Posts: 37 Karma: 10 Join Date: Oct 2020 Device: MacBook, iPhone, Kindle Paperwhite	How to migrate Content Server with user annotations? I have been using Content Server with authentication enabled on my local machine and had read several books with annotations made along the way. It works great and now I decided to move my library to a VPS (Ubuntu running on Amazon Lightsail, to be specific). I successfully set up a new Content Server with an new Calibre library, and I can now import my books into it. However, annotations I made on the local machine do not show (it is expected) since the library and its authentication are both new. The question I have is: what is the right way to migrate my library to the new Content Server? And how do I access my old highlights and notes made on the books?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
calibredb does not work with content server running (content server is using --enable	Irvin	Server	3	01-08-2019 02:47 AM
Content server password shown in "add new user" dialog	Phssthpok	Library Management	2	12-08-2017 07:50 AM
CC Content Server - do not display User Categories	filmgal	Devices	9	04-24-2013 03:11 AM
500 Internal Server Error accessing content server Calibre 0.8.8	DaddyO57	Calibre	1	07-20-2012 06:08 PM

03-01-2021, 07:54 AM	#2
kovidgoyal creator of calibre Posts: 43,859 Karma: 22666666 Join Date: Oct 2006 Location: Mumbai, India Device: Various	The annotations are stored in metadata.db simply copy over your library foder to the server.

03-01-2021, 09:37 AM	#4
georgehuang Enthusiast Posts: 37 Karma: 10 Join Date: Oct 2020 Device: MacBook, iPhone, Kindle Paperwhite	Just saw this thread: Viewer problem running behind Apache And yes I am also running Viewer with Apache. Guess this is the problem. I might have to try nginx instead.

Advert