Making a copy of library.db

[r5yk5 11]

I have been making a copy of library.db every hour to query with sqlite3. I read, somewhere today, that one should shutdown emby before making a copy but the article was old.

Is it safe to do what I've been doing? Or do I need to  make a daily copy in the middle of the night when it's not being used, having shut it down.

What are the dangers of copying the database when it's running?

Thanks

[Neminem 1518]

If you look at you DB library you see some sqlite files outside you DB.

These are cache files, waiting to be written to db, that is done on proper shutdown.

Without them written back to you DB will lead to issues, down the line.

This is the nature of SQLite, and if you ever hade the intension of moving the DB to a Network share.

Just dont.... 

 

 

Edited June 29, 2025 by Neminem

[r5yk5 11]

Ok thank you. I'd better have a look at the API then.