2010-10-18, 18:00
I feel like an idiot for having to ask this, but I'm not sure how to set up a shared database using MySQL on Linux. I am running Ubuntu 9.10 (Karmic Koala) and XBMC Dharma Beta 2 (r33778). I have three PCs running this same configuration that I want to share the database for, one of which is the server, which all the media resides on. Each PC has the same username as the default user, so all paths are the same and all media folders are mapped the same. i.e. every PC looks for videos at /home/mediacenter/videos. Currently I am using Dropbox to share the library, which works well, but has it's faults.
I just need a little help in how to get MySQL running. I've searched the forums, but I can't find some of the info I need. Right now I have the install steps as:
Install MySQL
Do some magic....
Change the video/music libraries as such on each PC:
Then continue using Dropbox to keep the thumbnails in sync, or just use rsync, etc. (I'd rather not just use a share to minimize loading time of thumbnails.)
First, the obvious question of how do I set up the actual database and tables? What is the magic step missing?
Also, will this automatically import my current library into the DB, or will I have to start from scratch?
Thanks!
I just need a little help in how to get MySQL running. I've searched the forums, but I can't find some of the info I need. Right now I have the install steps as:
Install MySQL
Code:
sudo apt-get install mysql-server
Do some magic....
Change the video/music libraries as such on each PC:
Code:
<videodatabase>
<type>mysql</type>
<host>xbmcserver</host>
<name>xbmc_video</name>
<user>xbmc</user>
<pass>xbmc</pass>
</videodatabase>
Code:
<musicdatabase>
<type>mysql</type>
<host>xbmcserver</host>
<name>xbmc_music</name>
<user>xbmc</user>
<pass>xbmc</pass>
</musicdatabase>
Then continue using Dropbox to keep the thumbnails in sync, or just use rsync, etc. (I'd rather not just use a share to minimize loading time of thumbnails.)
First, the obvious question of how do I set up the actual database and tables? What is the magic step missing?
Also, will this automatically import my current library into the DB, or will I have to start from scratch?
Thanks!