MediaPortal uses SQLite databases to manage the information storage on the different types of media. With this type of storage, access to your media can be done quickly and easily. These databases sit in the background and typically do not require any direct access. If however there is major changes required, it may be better to modify the database directly.
WARNING - USE AT OWN RISK!!!!!!! DO NOT ACCESS THE DATABASE IF YOU DO NOT KNOW WHAT YOU ARE DOING. Changes in these databases could render MediaPortal completely useless and a full re-installation of MediaPortal will be required. It is '''strongly recommended''' that a copy of the database be made so it can be restored if mistakes are made.
You may use SQLite Database Browser - a freeware program - to browse and modify MediaPortal databases.
Once you install and open the program, select the database to open. (This can be done by Selecting "File/Open Database")
The databases can be found in the sub folder called "Databases" within the MediaPortal Installation directory - (Default location) C:\Program Files\Team MediaPortal\MediaPortal\Databases
Here a list and description of each database (note the XX at the end of the name replaces the database version number.
|FolderDatabaseXX||Contains all the folders being used within all other databases of MediaPortal|
|MusicDatabaseXX||Contains all the information being used within Music section of MediaPortal|
|PictureDatabaseXX||Contains all the information being used within Pictures section of MediaPortal|
|ProgramDatabaseXX||Contains information about external applications MediaPortal is configured to use|
|RadioDatabaseXX||Contains the setup information for TV functionality. This database is not used if the TV-Server is implemented. Please read its documentation for database requirements|
|TVDatabaseXX||Contains the setup information for TV functionality. This database is not used if the TV-Server is implemented. Please read its documentation for database requirements|
|VideoDatabaseXX||Contains all the information being used within ?MyVideos section of MediaPortal|
Ensure MediaPortal is not running and you have opened the required database. Now you have the ability to export the contents of a table to a CSV (Comma Separated Value) type file which can then be opened in programs like Microsoft Excel or Microsoft Access. This will assist in doing repetitive changes (example. changing share folder name for all music files). It is recommended that MediaPortal not be running after an export is done if it is to be modified and re-imported. Doing so will cause new data added by MediaPortal to be lost during your export-import function as the new data is not in your CSV file. To export the table
Ensure MediaPortal is not running and you have opened the required database. Now you have the ability to import the contents of a CSV (Comma Separated Value) type file to a new table. When an import is done, the program only allows you to import data into a new table. The following steps outline the import process