Migrating the Video DB from XBMC Live Camelot to XBMC Live Dharma?
#1
Hello everyone,

Last night I installed the new version of XBMC Live Dharma (10) on my HTPC configured as follows:

- Samsung LE40M86BD Full HD 1080p
- HT 600W Philips MX999
- Bad Axe INTEL D975XBX i975X + Sata Raid + + PCIE + Lan
- Core 2 Duo E6600 2.4GHz/Sk775/1066/4MB
- Kingston HyperX DDR2 675 4GB (4x1GB Kit)
- Zalman CNPS 7700-Cu 20dB
- CLUB3D GeForce 7950GX2 1024MB DDR3 PCIE +
- Coolmaster 1000W Modular Power Supply + SATA + Silent
- Case chief tecba01-door
- 8 x SATA + 1 x IDE (12 Tera)
- MEDIA CENTER PVR REMOTE CONTROL KIT Vista
- Logitech Harmony 885
- Dino Mini Logitech Keyboard + Mouse
- APC Back-UPS RS 1500VA LCD 230V

After a perfect installation and edit the file for access to grub.cfg Multimedia Hard Drive I tried to change the old database to the new specifications for version Dharma through a series of SQL script below:

CREATE TABLE movie ( idMovie integer primary key, idFile integer, c00 text,c01 text,c02 text,c03 text,c04 text,c05 text,c06 text,c07 text,c08 text,c09 text,c10 text,c11 text,c12 text,c13 text,c14 text,c15 text,c16 text,c17 text,c18 text,c19 text,c20 text, c21 text);
CREATE UNIQUE INDEX ix_movie_file_1 ON movie (idFile, idMovie);
CREATE UNIQUE INDEX ix_movie_file_2 ON movie (idMovie, idFile)

CREATE TABLE country ( idCountry integer primary key, strCountry text);

CREATE TABLE countrylinkmovie ( idCountry integer, idMovie integer);
CREATE UNIQUE INDEX ix_countrylinkmovie_1 ON countrylinkmovie ( idCountry, idMovie);
CREATE UNIQUE INDEX ix_countrylinkmovie_2 ON countrylinkmovie ( idMovie, idCountry);


CREATE TABLE settings ( idFile integer, Deinterlace bool,ViewMode integer,ZoomAmount float, PixelRatio float, AudioStream integer, SubtitleStream integer,SubtitleDelay float, SubtitlesOn bool, Brightness float, Contrast float, Gamma float,VolumeAmplification float, AudioDelay float, OutputToAllSpeakers bool, ResumeTime integer, Crop bool, CropLeft integer,CropRight integer, CropTop integer, CropBottom integer, Sharpness float, NoiseReduction float, NonLinStretch bool, PostProcess bool);
CREATE UNIQUE INDEX ix_settings ON settings ( idFile )

delete from settings


CREATE TABLE path ( idPath integer primary key, strPath varchar(512), strContent text, strScraper text, strHash text, scanRecursive integer, useFolderNames bool, strSettings text, noUpdate bool, exclude bool);
CREATE UNIQUE INDEX ix_path ON path ( strPath )

update version set idVersion = 42, iCompressCount = 9


update files set strFilename = replace(strFilename,'/media/sdh1','/media/BE0027120026D167');
update files set strFilename = replace(strFilename,'/media/sdc1','/media/CA94C6DF94C6CCDF');
update files set strFilename = replace(strFilename,'/media/sde1','/media/2058A84258A81894');
update files set strFilename = replace(strFilename,'/media/sdf1','/media/52E62070E620568F');
update files set strFilename = replace(strFilename,'/media/sdb1','/media/681E2D8D1E2D557A');
update files set strFilename = replace(strFilename,'/media/sdi1','/media/56C0A0EDC0A0D491');
update files set strFilename = replace(strFilename,'/media/sdg1','/media/56028E5C028E40CB');



update path set strPath = replace(strPath,'/media/sdh1','/media/BE0027120026D167');
update path set strPath = replace(strPath,'/media/sdc1','/media/CA94C6DF94C6CCDF');
update path set strPath = replace(strPath,'/media/sde1','/media/2058A84258A81894');
update path set strPath = replace(strPath,'/media/sdf1','/media/52E62070E620568F');
update path set strPath = replace(strPath,'/media/sdb1','/media/681E2D8D1E2D557A');
update path set strPath = replace(strPath,'/media/sdi1','/media/56C0A0EDC0A0D491');
update path set strPath = replace(strPath,'/media/sdg1','/media/56028E5C028E40CB');



The data port is not been successful as I expected. In Video Library Navigation XBMC restarts quickly because of an unaspected error, while in the Navigation Video File info movie I appear correctly. I would like to avoid info scraper over 1200 movie trailers in High Definition.

Someone has already had the same need?

Does anyone know why XBMC Dharma no longer uses the traditional method of pointing to the internal hard drive?

example:

'/media/sdh1' is now '/media/BE0027120026D167'
'/media/sdc1' is now '/media/CA94C6DF94C6CCDF'
'/media/sde1' is now '/media/2058A84258A81894'
'/media/sdf1' is now '/media/52E62070E620568F'
'/media/sdb1' is now '/media/681E2D8D1E2D557A'
'/media/sdi1' is now '/media/56C0A0EDC0A0D491'
'/media/sdg1' is now '/media/56028E5C028E40CB'


My first intention was to export the information in XML, but Unfortunately, the export of the TV series and films have failed (Camelot Version).

Thanks!
Danilo Valente.
Reply
#2
To simplify things:

1) I have replaced the Video Database (Dharma version) with the backup of the old DB Video (version Camelot)
2) I restarted XBMC Live
3) by System> Settings> Video I exported the Video Library in XML format.
4) I edit the exported XML replacing the old Disk path with new Disk path
5) I deleted the database from which I exported the Video Library
6) I restarted XBMC Live
7) from System> Settings> Video I imported the Video Library from the XML edited

Works great!
DV
Reply

Logout Mark Read Team Forum Stats Members Help
Migrating the Video DB from XBMC Live Camelot to XBMC Live Dharma?0