Managing the MediaMonkey Database

From MediaMonkey Wiki
Jump to navigation Jump to search

Wiki Home > MediaMonkey 2024 Help > Reference Information > Managing the MediaMonkey Database



Introduction

The MediaMonkey database stores a lot of information about your media and some information like unsupported tags, unsaved tags, Playlists, Play History, Device Profiles, Service Profiles, Podcasts and Custom Tag names are only saved in the MediaMonkey database. As such backing up the database is highly recommended. Database maintenance is only suggested to be done when required (ie. search failing/MediaMonkey is slow).

Manage database dialog
Manage database dialog


Backup the MediaMonkey Database

MediaMonkey can be set to backup the database file (this doesn't include your media files), Addons and settings on a regular bases. Use File > Manage Database from the Main Menu to enable the database backup:

  • Enable Scheduled backup and set the frequency at which you want this to happen. MediaMonkey will automatically create a new backup at the set frequency in the same location as where the database file is located. MediaMonkey will create a new backup copy each time.
  • Set the location where the MediaMonkey database backup files should be stored.
  • Set Retain backups with how many backup copies you want to keep. Oldest backups will be deleted first when creating a new backup when the amount of backups stored is reached.
  • Select what should be backup up. You can select the Database, Settings and/or Addons. Settings and Addons are useful to backup when you're trying to migrate MediaMonkey.
  • Use Backup... if you want to manually create a backup of the MediaMonkey database, for example before updating MediaMonkey.


You can also manually backup the database file by creating a copy of it in File Explorer or using any backup software.


Restore Database from Backup

Use Restore from backup on the Manage Database dialog to select a backup file to restore and use.


Clearing the MediaMonkey Database

If you want to clear the MediaMonkey Database and start fresh use Clear database on the Manage Database dialog. This will delete the database file and restart MediaMonkey. You can also manually delete the database file while MediaMonkey is not running.

Note: This will remove all media files from the database; the metadata, including unsaved metadata (like Added, Played and others); Playlists and the files on them; Podcasts; Media Server settings; Sync settings; etc. There is no undo for this action!


Database Maintenance

Under Tools > Manage Database from the Main Menu Manage Database also has a few database maintenance options that will be run when you click OK on the Manage Database dialog.

  • Rebuild full-text search index will rebuild this index and can be run if Search isn't finding the right matches.
  • Optimize database will run some quick optimizations and can be used when MediaMonkey is becoming slow.
  • Rebuild database will rebuild the database from scratch (no data is lost) and can be used when there are problems with the database. This will take a while depending on how large the database is, during which MediaMonkey can't be used.
  • Clean URL cache, MediaMonkey caches online queries like a browser does to speed lookups up for features like Auto-Tag. This will clear the cache in MediaMonkey and will have MediaMonkey go online the next time the item is requested.


Related


English


Additional Help: Knowledge Base | Forum | MediaMonkey Support | MediaMonkey for Android Help | MediaMonkey 5 Help | MediaMonkey 4 Help