Welcome to our forums! Please take a few moments to read through our Community Guidelines (also conveniently linked in the header at the top of each page). There, you'll find guidelines on conduct, tips on getting the help you may be searching for, and more!

[Rel] - Plex2MySQL - Plex Media Server Library Exporter

lexus232lexus232 Members, Plex Pass Posts: 59 Plex Pass

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: )

Comments

  • daeksdaeks Members, Plex Pass Posts: 95 Plex Pass
    edited March 13

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

  • lexus232lexus232 Members, Plex Pass Posts: 59 Plex Pass

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

Sign In or Register to comment.