INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

Author Topic: how to clear deleted items from database?  (Read 1363 times)

comox

  • Galactic Citizen
  • ****
  • Posts: 428
how to clear deleted items from database?
« on: February 08, 2023, 03:54:00 pm »

I have a fuzzy recollection from years ago that MC has a hidden section in its database that records items deleted from the library.

Is this true and is there a way to clear it?

I've been pruning my library and would like to remove any clutter that might bog down performance.
Logged

JimH

  • Administrator
  • Citizen of the Universe
  • *****
  • Posts: 72446
  • Where did I put my teeth?
Re: how to clear deleted items from database?
« Reply #1 on: February 08, 2023, 04:39:34 pm »

In auto import, you can set the import to ignore previously deleted files or not.
Logged

JimH

  • Administrator
  • Citizen of the Universe
  • *****
  • Posts: 72446
  • Where did I put my teeth?
Re: how to clear deleted items from database?
« Reply #2 on: February 08, 2023, 05:05:18 pm »

But maybe you want to delete those files? 

Deleted files won't affect performance.  Slow drives would.  Antivirus can.
Logged

zybex

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 2620
Re: how to clear deleted items from database?
« Reply #3 on: February 08, 2023, 06:07:27 pm »

~d=r
Logged

comox

  • Galactic Citizen
  • ****
  • Posts: 428
Re: how to clear deleted items from database?
« Reply #4 on: February 09, 2023, 12:57:43 am »

~d=r

Thanks for the tip. Now I remember.

A search with ~d=r returns no files.
I have the auto-import option to ignore deleted files turned off.
Does that explain why no deleted files are being saved, or is it likely I've done the search wrong?
Logged

zybex

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 2620
Re: how to clear deleted items from database?
« Reply #5 on: February 09, 2023, 03:09:38 am »

Try it on the Video->Files or Audio->Files view.
The auto-import option doesn't change what is marked as deleted. Try importing a dummy file and then delete it to see if it shows up.
Logged

comox

  • Galactic Citizen
  • ****
  • Posts: 428
Re: how to clear deleted items from database?
« Reply #6 on: February 09, 2023, 03:32:06 am »

Thanks no luck.

I created a temporary view with Set rules for file display showing type=audio and added the modifier limit database to removed.

No files were displayed, yet I have deleted hundreds of audio files recently.
Logged

zybex

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 2620
Re: how to clear deleted items from database?
« Reply #7 on: February 09, 2023, 05:42:19 am »

Did you delete the files inside MC or in the filesystem directly? MC only shows files deleted using MC.
Maybe I'm wrong - it's possible that since you have the "ignore deleted" auto-import option enabled, deleted files are not tracked. I also have that option enabled disabled and I can see some deleted files when I use that filter.
Logged

bob

  • Administrator
  • Citizen of the Universe
  • *****
  • Posts: 13875
Re: how to clear deleted items from database?
« Reply #8 on: February 09, 2023, 08:08:14 am »

You can create a smartlist
Call it "bad or removed"
Don't choose any media type for the smartlist and limit the display to "database" check "bad" and "removed"

For me this is most useful for testing and when MC has seen a file with a media type it doesn't understand for some reason or another and you want to get MC to try import it again.
Logged

comox

  • Galactic Citizen
  • ****
  • Posts: 428
Re: how to clear deleted items from database?
« Reply #9 on: February 09, 2023, 11:52:13 am »

All the files I deleted were imported and deleted from within MC.

LOL, I have smartlists that I created many years ago and forgot about for inspecting the different databases.

My smartlist for showing Removed Files returns zero files.

Very strange.
Logged

marko

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 9143
Re: how to clear deleted items from database?
« Reply #10 on: February 09, 2023, 12:13:02 pm »

If the files are removed from the database only, they will show up in the 'removed' database as long as the file remains at the location MC expects it to be.

If you subsequently delete the file, or move it, MC will notice that and drop it from the 'removed' database.
If you have "Ignore Deleted" turned off in auto import, it will just re-import deleted files, and thus remove them from the 'removed' database.

If you remove files from the library that are in a location not covered by auto import, then those should remain in the 'removed' database as long as the file exists in the location it was at at the time it was deleted.

At least, that's my understanding of how it works, from my climb up the learning curve some years ago now. I have not tested any of the above in a long time, but I'm also unaware of any changes in this area. That does not mean there hasn't been mind you ;)

-marko

zybex

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 2620
Re: how to clear deleted items from database?
« Reply #11 on: February 09, 2023, 12:35:04 pm »

If you subsequently delete the file, or move it, MC will notice that and drop it from the 'removed' database.

Good point, I think that's it.
Logged

comox

  • Galactic Citizen
  • ****
  • Posts: 428
Re: how to clear deleted items from database?
« Reply #12 on: February 09, 2023, 02:52:11 pm »

Excellent, thanks guys for the explanation.

My precious database is clean. :)
Logged
Pages: [1]   Go Up