[Rel] - Plex2MySQL - Plex Media Server Library Exporter

Dev Community Dev/API Corner
1

Howdy,Plex community!
Plex2MySQL is a script that exports your media library to mysql, so that you can debug or do whatever you will with it.
This script was originally made for webDash, my other project. But I decided to release this one , as well.
How to use it? Just edit /inc/config.php and set $rpassword to whatever, also make sure you set your credentials for MySQL, then simply run everything from sql_to_exec in phpmyadmin or navicat.

What each file does?:

  • add_movies : adds movies to the database
  • add_music ; adds artists to the database
  • add_albums ,adds albums to the database
  • add_tracks , adds music tracks to the database
  • refresh_content is just for recently_added content.

Enjoy! Cheers, Alex :smile: )

2

just as an addition: It could be also achieved by directly accessing the sqlite db :slight_smile:
Location: appdata_path/Plug-in Support/Databases/com.plexapp.plugins.library.db
Example DB Viewer: Bitbucket

3

i am aware. but this is for lazy people. plus, it gives oyu a ton of options if you wanna play around with tables.

4

can you please be more specific when you say “simply run everything from sql_to_exec in phpmyadmin”

I modified the config … I created a database called “plex_data” … am I suppose to manually create the tables too?

5

hello. sorry for the late reply. no. just import the sql file inside php my admin. or open up the .sql file and CTR-C CTRL-V the queries inside the run query tab. But i would personally go with the query import.