I had a lack-of-response over at their forum:-

http://sickbeard.com/forums/viewtopic.php?f=3&t=6613

 

Is it as simple as copying the sickbeard.db file over?

 

EDIT:- Meant to post this in "Applications", but, I guess this works too.

I can't give you an 100% but that should work, I don't really see why not.

I can't give you an 100% but that should work, I don't really see why not.

 

Same, however, the only issue is that my current HDD (For windows) is the drive I want to use as a cache drive, so, I have to do this whole musical chair like motion of switching drives and back forth to make sure I lose no data in the whole ordeal, this meaning that I won't be able to install sickbeard (To the cache drive) until after I've reinstalled windows, and, although I will have a backup of the sickbeard directory, I'm not too sure how well it'll run (To retest it) after I completely wipe all registry/appdata/temp folders/keys.

just copying the config file and the DB will do

 

BUT your paths will be probably different when you move things to unraid

so you might need to update all your paths

 

you can see this when you open sickbeard on the series page when it says dir missing ....

just copying the config file and the DB will do

 

Okay, thanks.

 

BUT your paths will be probably different when you move things to unraid

so you might need to update all your paths

 

you can see this when you open sickbeard on the series page when it says dir missing ....

 

Yeah, in the link I linked in the OP I noted that. It won't be really hard do, pretty sure any SQLite database browser will allow me to quickly modify all of that.

just copying the config file and the DB will do

 

Okay, thanks.

 

BUT your paths will be probably different when you move things to unraid

so you might need to update all your paths

 

you can see this when you open sickbeard on the series page when it says dir missing ....

 

You can actually update the paths right in sick beard. Manage -> Mass Update, select all edit check boxes then just update the path.

 

Yeah, in the link I linked in the OP I noted that. It won't be really hard do, pretty sure any SQLite database browser will allow me to quickly modify all of that.

just copying the config file and the DB will do

 

Okay, thanks.

 

BUT your paths will be probably different when you move things to unraid

so you might need to update all your paths

 

you can see this when you open sickbeard on the series page when it says dir missing ....

 

Yeah, in the link I linked in the OP I noted that. It won't be really hard do, pretty sure any SQLite database browser will allow me to quickly modify all of that.

You can actually update the paths right in sick beard. Manage -> Mass Update, select all edit check boxes then just update the path.

 

You failed your quoting, fixed it for you. Also, I didn't know that, that'll make it easier once my new build's PSU comes... if it ever does.

I just did this, seems to work (Only tested with 1 show), if anyone wants to know how to do it:-

 

1. Download a sqlite browser (Such as this)

2. Load sickbeard.db

3. Execute this sql code:-

update tv_shows set location = replace(location, "Y:\TV Shows", "/mnt/user/TV Shows");

 

Replace "Y:\TV Shows" with your old (windows) directory and "/mnt/user/TV Shows" with your new (linux) directory.

Im going to be building my server in about a week.  Currently my tv shows/movies are on one 3tb with about 2tb of stuff.  My tv shows are pretty fragmented with noseason/season03/season3 etc named folders.  What is the easiest way to "feed" sickbeard from the cache drive?  The dumb slow way would be to copy files from the windows pc to the sickbeard watch folder and have sickbeard sort/rename and pop them on the unraid share.  However is there a quicker/easier way like hooking up the gpt 3tb to the unraid box and have sickbeard "see" the 3tb inside the watch folder?

I just did this, seems to work (Only tested with 1 show), if anyone wants to know how to do it:-

 

1. Download a sqlite browser (Such as this)

2. Load sickbeard.db

3. Execute this sql code:-

update tv_shows set location = replace(location, "Y:\TV Shows", "/mnt/user/TV Shows");

 

Replace "Y:\TV Shows" with your old (windows) directory and "/mnt/user/TV Shows" with your new (linux) directory.

 

you are my hero ( ok just below influencer )

 

worked like a dream - moved from windows to unraid - and only needed to perform your steps on the sickbeard.db

 

thx a mil

I know this is an old one but in case someone gets here by google, if you have your shows nested in sub folders so y:\tvshowname\season etc then a slight addition is to use replace to change the path over but keep the sub folder info

 

update tv_shows set location= replace(replace(location,"\","/"),"Y:","/media/TV")

 

so switch around the slashes and change from Y: (which was mapped over to the tv shows folder) to /media/TV which is the new fstab share on the linux box

 

Cheers all

or you could just go to Manage > Mass Update > check off 'edit' for all the shows and fix the root dir to the correct location.

or you could just go to Manage > Mass Update > check off 'edit' for all the shows and fix the root dir to the correct location.

 

I did mention this in the sixth post of this thread but seems some people like to do it the hard way. 

 

or you could just go to Manage > Mass Update > check off 'edit' for all the shows and fix the root dir to the correct location.

 

I did mention this in the sixth post of this thread but seems some people like to do it the hard way. 

 

The hard way seems to be the only way as far as I can tell. Trying to Mass Update the Root Directory just seems to try to tack on the new path to the front of the old path. I get the error "New location /mnt/E/Video/TV Shows/E:\Video\TV Shows\(show) does not exist" on every show.

I just did this, seems to work (Only tested with 1 show), if anyone wants to know how to do it:-

 

1. Download a sqlite browser (Such as this)

2. Load sickbeard.db

3. Execute this sql code:-

update tv_shows set location = replace(location, "Y:\TV Shows", "/mnt/user/TV Shows");

 

Replace "Y:\TV Shows" with your old (windows) directory and "/mnt/user/TV Shows" with your new (linux) directory.

or just go to manage > mass update > check off 'edit' for all shows and hit submit. then moidfy the root dir 'Y:\' to '/mnt/user/'. done

Do I need to copy all the files from the Sickbeard directory?  There are sub directories called cache, data, lib, logs.  Do I need to copy these over?  Also, there are .db.v1, .db.v2, etc. files.  I am assuming that this are just backup files and don't need to be copied.  Same goes for the ini file.  There are .ini.v1, ini.v2, etc.