Kodi Community Forum

I assume it would be the opposite of how you backed it up.

If you copied it, copy it back.

If you used a program it should have a restore function.

(2016-04-30, 20:46)BatterPudding Wrote: [ -> ]Database Backups
Even time a scrub is performed, we make a backup of the SQLite database. These are stored in a backups folder underneath the KODI database folder. These backups can be disabled in the settings but we STRONGLY suggest you leave the backup enabled.

In our addon's settings it is possible to change the name of the backups if you want to make a specific test. This backup name will have a date and timestamp attached and then copied to a sub folder. testclean1_2016-04-26_1345.db If no name is supplied then the backups use the standard name of the backup and attach a datestamp MyVideos99_2016-04-26_1345.db. When you first install the add-on, it defaults to no defined string in the name, so the add-on by default uses the SQLite db name.

MySQL users need to make your own backups. But as you have moved into the advanced world of MySQL I assume you already know all about backups.

The first post shows where the file is backed up, you need to copy it back over your main database file.

The program that created my backup is the Video Database Cleaner (I named it after my name in the settings). I tried using the official kodi “Backup” addon but I couldn’t find my .db file when trying the restore option.

It’s my first time trying to restore. When you say copy it back, where exactly in my kodi files? Thank you.

Perfect, thanks. So I basically just cut it out of the /backups folder and simply paste it in my Database folder where all my other .db files are located? (MyVideos, Textures etc.)

(2023-01-12, 20:07)Doupsii_ Wrote: [ -> ]It’s my first time trying to restore. When you say copy it back, where exactly in my kodi files? Thank you.

It depends on your OS as to the exact location, but in general it is userdata/Database/backups.  The location of the userdata directory is what changes depending on the OS Kodi running on.

I’m running Kodi on an android box so yes this is the exact location. Do you suggest any file app I could use to copy it into my main Database file?

(2023-01-12, 20:10)black_eagle Wrote: [ -> ]

(2023-01-12, 20:07)Doupsii_ Wrote: [ -> ]It’s my first time trying to restore. When you say copy it back, where exactly in my kodi files? Thank you.

It depends on your OS as to the exact location, but in general it is userdata/Database/backups.  The location of the userdata directory is what changes depending on the OS Kodi running on.

Thank you for your answer. I just copied it into my main Database file, rebooted Kodi but my library remained the same. Did I miss a step?

I figured it out thank you for your help eveyone!

Hi guys!

I have a couple orphaned entries like:

But I couldn't clean the Database, even using "Deep Clean" and selecting the source containing those entries. How can I find and clean orphaned files like that with the cleaner?

Thank you in advance!

(2023-01-15, 22:59)larsete Wrote: [ -> ]But I couldn't clean the Database.

Why do you have movies in your music source(s) ?

Sorry I just picked up a line from the logs and edited it to make the example, but the movies are not really in the music library or the other way around. I just wanted to know if it is possible to find and clean orphaned files like those from the library?

Thanks again!

Hi! Has anyone tried this yet with v20 Nexus?

Yes, pretty much everybody who has read this thread.

@csnolle doesn't work always gives an error it has to be modified probably to work with Nexus

(2023-01-28, 20:29)gemini88 Wrote: [ -> ]it has to be modified probably to work with Nexus

That would have to be done by @kenmills, the current/latest author of this add-on.
Or, someone willing to fork and update it.