Missing Catagories or Database.
Moderators: XnTriq, helmut, xnview
-
- Posts: 8
- Joined: Sat Sep 28, 2019 3:29 am
Missing Catagories or Database.
I think I may of wiped out the database.
So I have the database and all the files on an external Hard Drive and when I opened up XnView MP, none of the catagories populated in the pane as they should had. My drive was obviously plugged in as I was accessing through XnView the drive where I also have pictures stored. So I unplugged the drive, and plugged it back in and still, the catagories didn't populate. I forgot how to then check the file paths and tried to click on the catagories itself in the data pane and I think I wiped out all the catagories on mistake.
Is there a way to get them back or did I really lose all of my catagories and all associated tagged pictures, no not deleted the pictures, the category tags that were on the pictures.
So I have the database and all the files on an external Hard Drive and when I opened up XnView MP, none of the catagories populated in the pane as they should had. My drive was obviously plugged in as I was accessing through XnView the drive where I also have pictures stored. So I unplugged the drive, and plugged it back in and still, the catagories didn't populate. I forgot how to then check the file paths and tried to click on the catagories itself in the data pane and I think I wiped out all the catagories on mistake.
Is there a way to get them back or did I really lose all of my catagories and all associated tagged pictures, no not deleted the pictures, the category tags that were on the pictures.
-
- Author of XnView
- Posts: 45193
- Joined: Mon Oct 13, 2003 7:31 am
- Location: France
Re: Missing Catagories or Database.
the drive/path has not changed? which filesize for your xnview.db?
Pierre.
-
- Posts: 8
- Joined: Sat Sep 28, 2019 3:29 am
Re: Missing Catagories or Database.
Same drive path with a DB file the size of 32,924 KB.
-
- Author of XnView
- Posts: 45193
- Joined: Mon Oct 13, 2003 7:31 am
- Location: France
-
- Posts: 8
- Joined: Sat Sep 28, 2019 3:29 am
Re: Missing Catagories or Database.
I had catagories that may dox me. So if anything is still recoverable then that might not be wise for myself.
-
- Posts: 8
- Joined: Sat Sep 28, 2019 3:29 am
Re: Missing Catagories or Database.
Is this an issue that may be resolved in someone walks one through the process to go figure what went wrong?
-
- Author of XnView
- Posts: 45193
- Joined: Mon Oct 13, 2003 7:31 am
- Location: France
Re: Missing Catagories or Database.
i need to check the content of database file, please send me it
Pierre.
-
- Posts: 8
- Joined: Sat Sep 28, 2019 3:29 am
Re: Missing Catagories or Database.
As I aforementioned there is sensitive information with in the DataBase however I were looking elsewhere to find solutions. SQLite allows me to view the DB file and all the tags are wiped clean, this is unfortunate. The DB file still contains the Table for the Folders, which as I thought WOULD dox me as well as the Table for images. I am scratching my chin to why the Catagories got wiped.
I was about to give up on this as I started re tagging everything again, using another file path to not affect the one that got wiped. Then I discovered on my other computer a copy of the DataBase as it were 2 years ago, still not up to date with everything added in 2 years, but it is a start. Question is, with what I were retaging, can I combined that with the old DB to save me all the efforts? I think this is as good as it is going to get and I just want to know, what wiped the DB to begin with and what safe gaurds are there to prevent this other then starting to make routine back ups of the DB periodically.
-
- Author of XnView
- Posts: 45193
- Joined: Mon Oct 13, 2003 7:31 am
- Location: France
Re: Missing Catagories or Database.
Strange, you don't save categories in XMP metadata? You old DB use same folder structure?
Pierre.
-
- Posts: 8
- Joined: Sat Sep 28, 2019 3:29 am
Re: Missing Catagories or Database.
My level of expertise on databases is small, so forgive me when I say, I have no idea what you are talking about. Though, I'm not a complete idiot, I can create websites pretty well and get paid for it so... Just another set of jargon. Any how, the structure of XNview that I have is everything being in that XnView.db file. There is no additional data the files themselves contain as most Jpegs allow for, as I save in PNG. Loseless data is best data.
I noticed that I can export categories into a text, xml, or Json But can they be merged? And yes, pretty much each DB references the same folders for the most part, other than in 2 years time, new folders were obviously created and so new files as well. I don't think that should be hard to do, should it? Scratching my chin at it as You have a file, it's location, and the tags associated though the location is what may be indexed differently between the two databases. Hmm perhaps it is a bit more complex than I thought....
-
- Author of XnView
- Posts: 45193
- Joined: Mon Oct 13, 2003 7:31 am
- Location: France
-
- Posts: 2
- Joined: Mon Aug 14, 2023 6:47 am
Re: Missing Catagories or Database.
Unplugging and replugging an external hard drive while XnView MP is running can lead to the accidental deletion of the category database file (xnview.db). This file is crucial for maintaining the organization and categorization of your photos within XnView MP. If you suspect that this file has been deleted, you will need to rebuild the category database from scratch.
To prevent such data loss and ensure the integrity of your category database, consider integrating XnView MP with a robust B2B API integration solution. B2B API integration seamlessly connects XnView MP to a cloud-based data storage system, enabling real-time backup and synchronization of your category database. This eliminates the risk of data loss due to accidental deletion or hardware failures.
With B2B API integration, you can maintain a centralized repository of your category database, ensuring that your photo organization remains consistent across all devices and platforms. Additionally, B2B API integration facilitates seamless collaboration among team members, enabling them to access and update the category database simultaneously.
If you value the organization and categorization of your photos, investing in B2B API integration for XnView MP is a wise decision that safeguards your valuable data and enhances collaboration efficiency.
To prevent such data loss and ensure the integrity of your category database, consider integrating XnView MP with a robust B2B API integration solution. B2B API integration seamlessly connects XnView MP to a cloud-based data storage system, enabling real-time backup and synchronization of your category database. This eliminates the risk of data loss due to accidental deletion or hardware failures.
With B2B API integration, you can maintain a centralized repository of your category database, ensuring that your photo organization remains consistent across all devices and platforms. Additionally, B2B API integration facilitates seamless collaboration among team members, enabling them to access and update the category database simultaneously.
If you value the organization and categorization of your photos, investing in B2B API integration for XnView MP is a wise decision that safeguards your valuable data and enhances collaboration efficiency.