Kodi Community Forum
HOW-TO:Share libraries using MySQL: Wiki Edition - Printable Version

Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: Tips, tricks, and step by step guides (https://forum.kodi.tv/forumdisplay.php?fid=110)
--- Thread: HOW-TO:Share libraries using MySQL: Wiki Edition (/showthread.php?tid=157572)

Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40


RE: HOW-TO synchronize XBMC between every room in the house: Wiki Edition - EddieB606 - 2013-03-21

(2013-03-21, 02:50)Ned Scott Wrote:
(2013-03-20, 21:24)SchattenMann Wrote: i was wondering: why does the wiki guide doesn't say the user can simply export the SQLite database and import it on MySQL...

I mean it took me 15 min to do it after i got tired of fussing around with Import/Export database...

Didn't know it was an option. Can you tell me more about the steps involved?

Yes, please share because after several attempts, I just can't seem to get this to work right and it looks like I can't get any help. LOL


RE: HOW-TO synchronize XBMC between every room in the house: Wiki Edition - keisuji - 2013-03-21

(2013-03-19, 23:39)Tyler Durden Wrote: What am I doing wrong !?

Code:
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| master usermusic32 |
| master uservideo75 |
| mysql              |
| performance_schema |
| test               |
+--------------------+
6 rows in set (0.08 sec)

mysql> select count(*) from master uservideo75.movie;
ERROR 1046 (3D000): No database selected
mysql> select count(*) from master uservideo75.tvshow;
ERROR 1046 (3D000): No database selected
mysql> select count(*) from master usermusic32;
ERROR 1046 (3D000): No database selected
mysql>

The databases appear to have been made, but I cannot get a count from them.

Help!



you need to select the database with this command
use databasename; -> use master uservideo75;


RE: HOW-TO synchronize XBMC between every room in the house: Wiki Edition - SchattenMann - 2013-03-21

(2013-03-21, 03:35)EddieB606 Wrote:
(2013-03-21, 02:50)Ned Scott Wrote:
(2013-03-20, 21:24)SchattenMann Wrote: i was wondering: why does the wiki guide doesn't say the user can simply export the SQLite database and import it on MySQL...

I mean it took me 15 min to do it after i got tired of fussing around with Import/Export database...

Didn't know it was an option. Can you tell me more about the steps involved?

Yes, please share because after several attempts, I just can't seem to get this to work right and it looks like I can't get any help. LOL

Sure,

Open your SQLite database with SQLite Manager Extension for firefox
Go to Tools - Options - Main - Characters to enclose the identifiers with = Grave Accents ``
Go to Database - Export Database

If you are starting a clean database you can just import the SQL file. My XBMC installation had already created a clean MyVios75 and MyMusic32 so i used that database instead of creating a new one therefor i will comment all "Create" stuff.

Open the file with Notepad++
Find and Replace "Drop Table" with "Truncate Table" -> this will make sure the tables are clean, don't do it if it's already a clean table
Find and Replace "Create Table" with "-- Create Table" -> my tables are already created, don't do it if it is a clean database
Find and Replace "Create View" with "-- Create View" -> my tables are already created, don't do it if it is a clean database
Find and Replace "Create Trigger" with "-- Create Trigger" -> my tables are already created, don't do it if it is a clean database
Find and Replace "Create Index" with "-- Create Index" -> my tables are already created, don't do it if it is a clean database
Find and Replace "Create Unique Index" with "-- Create Unique Index" -> my tables are already created, don't do it if it is a clean database

99% of the work is done. You probably should take a look and search for names with a ': Mike O'Dole for example. Your script will have this cases like Mike O''Dole and this will generate errors. You have two options:

either

Start Running your script and, when you have an error, solve it and run it again;

or

Find and Replace '' with \'
Find and Replace ,\', with ,'',

By now you should have nothing else to do but import the script. You can run it as many times as you want until it goes through. Don't worry to much with errors, just read them and correct it...if there are any it will be simple differences between SQLite and MySQL syntax.

Have fun your XBMC installation that is EXACTLY equal as it was before


RE: HOW-TO synchronize XBMC between every room in the house: Wiki Edition - jonatan - 2013-03-21

Will mysql work with xbmc launcher?

Thanks


RE: HOW-TO synchronize XBMC between every room in the house: Wiki Edition - SchattenMann - 2013-03-21

no idea...can't see why not


RE: HOW-TO synchronize XBMC between every room in the house: Wiki Edition - ivanmmj - 2013-03-23

You can also use MariaDB 5.5 instead of MySQL 5.5. It's reported to be faster, too. I've been thinking of moving the database from my server to my router, though... 128mb of RAM, have it store the database in an external drive alongside the movies and have that act as both the SMB or NFS server as well as the MySQL server... but I don't know if I want to potentially slow down the router. lol

(2013-03-21, 15:39)jonatan Wrote: Will mysql work with xbmc launcher?

Thanks

Yes, I use it on two media centers that currently run windows and it works fine.

(2013-02-28, 03:26)SandmanCL Wrote: This guide does not cover the synchronization of thumbnails. Currently I am using rsync to make sure the Thumbnails directory is in sync between my XBMC master and my ATV2 clients. This worked perfectly on Eden, but with Frodo I need to additionally sync Textures13.db, but even after doing this I need to restart XBMC on the ATV clients in order for the Thumbnails to show up.

I feel this is a step in the wrong direction and I'm hoping I'm missing some crucial point that would make it easier.

Frodo automatically syncs thumbnails. Just export your library to seperate files, set the MySQL database, import the library, done. Each client will automatically create a local cache of the thumbnails.


RE: HOW-TO synchronize XBMC between every room in the house: Wiki Edition - jonatan - 2013-03-23

Im interested in this
Quote:You can also use MariaDB 5.5 instead of MySQL 5.5.
How would i go about this since iv already set my sql up
mysql takes for ever to load posters thumbs

Thanks


RE: HOW-TO synchronize XBMC between every room in the house: Wiki Edition - ivanmmj - 2013-03-27

(2013-03-23, 17:20)jonatan Wrote: Im interested in this
Quote:You can also use MariaDB 5.5 instead of MySQL 5.5.
How would i go about this since iv already set my sql up
mysql takes for ever to load posters thumbs

Thanks

It depends on what OS you are using for the server. Here is Ubuntu 12.04's guide. It's a drop in replacement so no need to export and import the database. (although backing up is always recommended.) I'll try to write up better instructions tomorrow when I'm not typing this on a phone. lol
As far the slow loading of thumbnails, I suggest you limit the resolution on the computer having the problem. That can make a huge difference.


RE: HOW-TO synchronize XBMC between every room in the house: Wiki Edition - ivanmmj - 2013-03-28

(2013-02-25, 22:27)Ned Scott Wrote: http://wiki.xbmc.org/index.php?title=HOW-TO:Sync_multiple_libraries

Would you be interested in an addition to the Wiki on how to set this up in Arch with MySQL and/or MariaDB? I'm thinking of moving my server from Ubuntu to Arch as it's the only machine in the house that still runs Ubuntu and I figured I could always make a walkthrough as I do it.


RE: HOW-TO synchronize XBMC between every room in the house: Wiki Edition - Birdincamera - 2013-03-28

Have this set up as per Howtogeek and it works ok, however it states you can have this work with a MySQL server that is always on or nearly always on. Being a green kiind of person I have set my server (also the TV server) to sleep after x minutes and my clients to send a WOL magic packet to wake the server, epg gets updated and I am up and running in about 10 seconds. If the server is on when XBMC is launched (at start up), then the database is updated, however if the server is asleep, XBMC hangs - I figure because xbmc is trying to query the database before a WOL is sent (using Advanced Wake On LAN) but the server is asleep.

Is there any way to delay the query until after the WOL magic packet is sent and the server is up.


RE: HOW-TO synchronize XBMC between every room in the house: Wiki Edition - Ned Scott - 2013-03-28

(2013-03-28, 01:49)ivanmmj Wrote:
(2013-02-25, 22:27)Ned Scott Wrote: http://wiki.xbmc.org/index.php?title=HOW-TO:Sync_multiple_libraries

Would you be interested in an addition to the Wiki on how to set this up in Arch with MySQL and/or MariaDB? I'm thinking of moving my server from Ubuntu to Arch as it's the only machine in the house that still runs Ubuntu and I figured I could always make a walkthrough as I do it.

That would be awesome.


RE: HOW-TO synchronize XBMC between every room in the house: Wiki Edition - ivanmmj - 2013-04-01

(2013-03-28, 10:53)Ned Scott Wrote:
(2013-03-28, 01:49)ivanmmj Wrote:
(2013-02-25, 22:27)Ned Scott Wrote: http://wiki.xbmc.org/index.php?title=HOW-TO:Sync_multiple_libraries

Would you be interested in an addition to the Wiki on how to set this up in Arch with MySQL and/or MariaDB? I'm thinking of moving my server from Ubuntu to Arch as it's the only machine in the house that still runs Ubuntu and I figured I could always make a walkthrough as I do it.

That would be awesome.

Alright. As soon as I get some free time to backup//reformat my server so I can migrate it, I will write up the how to. Seeing as Arch just recently switched from MySQL to MariaDB as the default SQL database, I will be making it just for MariaDB. There will be NO extra steps required to make it work instead of MySQL.


RE: HOW-TO synchronize XBMC between every room in the house: Wiki Edition - Ned Scott - 2013-04-01

Hey, if MariaDB works better, by all means, go for it.


RE: HOW-TO synchronize XBMC between every room in the house: Wiki Edition - winestock - 2013-04-02

(2013-03-28, 01:49)ivanmmj Wrote:
(2013-02-25, 22:27)Ned Scott Wrote: http://wiki.xbmc.org/index.php?title=HOW-TO:Sync_multiple_libraries

Would you be interested in an addition to the Wiki on how to set this up in Arch with MySQL and/or MariaDB? I'm thinking of moving my server from Ubuntu to Arch as it's the only machine in the house that still runs Ubuntu and I figured I could always make a walkthrough as I do it.

I converted over not too long ago from mysql to mariadb for ALARM. Are you planning on updating: http://wiki.xbmc.org/index.php?title=HOW-TO:Sync_multiple_libraries/Setting_up_MySQL/ALARM? I was planning on submitting some changes to Ned on this.

When you setup mariadb I suggest that you try out the myisam storage engine which I found was a lot faster then the default innodb storage engine for the purposes of XBMC.


RE: HOW-TO synchronize XBMC between every room in the house: Wiki Edition - ivanmmj - 2013-04-03

(2013-04-02, 01:34)winestock Wrote:
(2013-03-28, 01:49)ivanmmj Wrote:
(2013-02-25, 22:27)Ned Scott Wrote: http://wiki.xbmc.org/index.php?title=HOW-TO:Sync_multiple_libraries

Would you be interested in an addition to the Wiki on how to set this up in Arch with MySQL and/or MariaDB? I'm thinking of moving my server from Ubuntu to Arch as it's the only machine in the house that still runs Ubuntu and I figured I could always make a walkthrough as I do it.

I converted over not too long ago from mysql to mariadb for ALARM. Are you planning on updating: http://wiki.xbmc.org/index.php?title=HOW-TO:Sync_multiple_libraries/Setting_up_MySQL/ALARM? I was planning on submitting some changes to Ned on this.

When you setup mariadb I suggest that you try out the myisam storage engine which I found was a lot faster then the default innodb storage engine for the purposes of XBMC.

The only thing I'd be afraid of with using myisam would be loss of data integrity. But then again, my server has a battery backup... Maybe I'll check it out. Have you tried any of the other storage engines?


This forum uses Lukasz Tkacz MyBB addons.