Move SQL database

badbob · 2008-03-23, 13:21

Is it possible to have a SQL database built from the various directories, as I find browsing by directory quite slow. Also have several hard drives, so rather than just one big "movies" and "TV Shows" I have several.

A bit like Squeezebox music database. Music can be anywhere, and browsing is really quick

milhouse · 2008-03-23, 13:26

Any of the database views do just this. If you have already scanned your directories in configuration (e.g. Movies->Database->Scan tab) , then you can switch view to "Title" rather than "Share".

badbob · 2008-03-23, 15:30

Cheers didn't spot that, however it has several instances of the same TV series.

milhouse · 2008-03-23, 16:00

A couple of options:

1) (what I do) You can stack the files. Go into the movie database editor tab, delete all but one of the records for a series. Then edit the remaining one and add multiple video files to it. Personally, I keep one record for each season, and stack the files by season.

2) Check out the My TVSeries plugin. Handle episodes and seasons is exactly what this plugin is designed to do.
Link here

badbob · 2008-03-24, 13:51

Doesn't seem to work that well, probably because of file naming. Would it be possible to create a database, then the files under that directory in that list, just from the directories alone? For example I have

C:\TV Series\Mash
D:\TV Series\Friends
E:\TV Series\Alias

As it is you would have three listings in My Videos, but if the database could do this

\TV Series
Alias
Friends
Mash

cheetah05 · 2008-03-26, 13:12

Quote:

Originally Posted by badbob

Doesn't seem to work that well, probably because of file naming. Would it be possible to create a database, then the files under that directory in that list, just from the directories alone? For example I have

C:\TV Series\Mash
D:\TV Series\Friends
E:\TV Series\Alias

As it is you would have three listings in My Videos, but if the database could do this

\TV Series
Alias
Friends
Mash

....I thought this is what the TV Series plugin was supposed to do?

2008-03-23, 13:21	#1 (permalink)
badbob Portal Member Join Date: May 2007 Age: 52 Posts: 24 Thanks: 0 Thanked 0 Times in 0 Posts	Move SQL database Is it possible to have a SQL database built from the various directories, as I find browsing by directory quite slow. Also have several hard drives, so rather than just one big "movies" and "TV Shows" I have several. A bit like Squeezebox music database. Music can be anywhere, and browsing is really quick

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Move My Video database to a network server	dstone	Improvement Suggestions	1	2007-01-23 07:38
move database / files moved location	chenks	General Support	0	2006-11-17 19:25
SQL error: database disk image is malformed	Basz	WebEPG	6	2006-09-20 19:35
Select Channels and start/end time from SQL Database	Tauren	Plugins	7	2006-03-02 14:11
Database Related - Backup w. Export/Import to from SQL-File	Anonymous	General Development (no feature request here!)	0	2004-09-06 10:37

2008-03-23, 13:26	#2 (permalink)
milhouse Portal Member Join Date: Nov 2006 Location: Minneapolis, MN U.S. Age: 34 Posts: 172 Thanks: 2 Thanked 11 Times in 10 Posts Country: My System	Any of the database views do just this. If you have already scanned your directories in configuration (e.g. Movies->Database->Scan tab) , then you can switch view to "Title" rather than "Share".

2008-03-23, 15:30	#3 (permalink)
badbob Portal Member Join Date: May 2007 Age: 52 Posts: 24 Thanks: 0 Thanked 0 Times in 0 Posts	Cheers didn't spot that, however it has several instances of the same TV series.

2008-03-23, 16:00	#4 (permalink)
milhouse Portal Member Join Date: Nov 2006 Location: Minneapolis, MN U.S. Age: 34 Posts: 172 Thanks: 2 Thanked 11 Times in 10 Posts Country: My System	A couple of options: 1) (what I do) You can stack the files. Go into the movie database editor tab, delete all but one of the records for a series. Then edit the remaining one and add multiple video files to it. Personally, I keep one record for each season, and stack the files by season. 2) Check out the My TVSeries plugin. Handle episodes and seasons is exactly what this plugin is designed to do. Link here

2008-03-24, 13:51	#5 (permalink)
badbob Portal Member Join Date: May 2007 Age: 52 Posts: 24 Thanks: 0 Thanked 0 Times in 0 Posts	Doesn't seem to work that well, probably because of file naming. Would it be possible to create a database, then the files under that directory in that list, just from the directories alone? For example I have C:\TV Series\Mash D:\TV Series\Friends E:\TV Series\Alias As it is you would have three listings in My Videos, but if the database could do this \TV Series Alias Friends Mash