How to preserve channel list and channel group setting when updating TV Server

mpfrank · 2007-02-21, 13:23

Hi guys,

I'm testing the new TVServer with latest svn builds of MP.
Everytime I update the TVServer I have to scan again for the channels (because channel lists are empty in TVServer config) and have to build my channel groups and sorting from scratch.

As I am using DVB-S I receive around 800 channels and it's a hard and stupid work to put them again in order, building my own groups and map the channels to these individual groups.

Is there a way how to preserve these setting, may be by exporting before updating and importing after updating?

Thanks & cheers
mpFrank

regeszter · 2007-02-21, 13:33

there is a channel export/import function in tvsetup

gibman · 2007-02-21, 13:34

I did the same painful experience.
Spending hours on grouping things renaming channels etc.

I did several tvserver SVN updates until one day the database was reset.
All my channels and stuff were gone.

Now I am doing a backup of the tvlibrary database making restores possible.

U might get into trouble if the database schema is altered.
Ex. a new field is added to a table.

But it's better than nothing.

I guess it's the price we pay for testing the latest and greatest SVN builds.

/Gibman

mpfrank · 2007-02-21, 14:11

Quote:

there is a channel export/import function in tvsetup

I tried this too. Exporting is not the problem, but importing ends up with an error-msg. I found no way to handle it.

Quote:

I did several tvserver SVN updates until one day the database was reset.
All my channels and stuff were gone.

All updates I made with TVServer leeds to empty channel lists and groups.

I think this is really the price I have to pay...

Cheers
mpFrank

gibman · 2007-02-21, 19:57

Then just do the backup of the tvlibrary database before installing a new SVN build.

Then restore the database if the new SVN build has dropped/recreated all your tables (channels and groups).

/Gibman

defcon5 · 2007-02-22, 13:24

Interesting Gibman

Could you explain how can we do a channel list backup from SQL database?
I use Import/export option only

frodo · 2007-02-22, 13:36

Quote:

Then just do the backup of the tvlibrary database before installing a new SVN build.

Then restore the database if the new SVN build has dropped/recreated all your tables (channels and groups).

Very very bad idea
The tv database is not dropped for nothing.
The reason is that the database scheme has changed
e.g. new tables, or fields added.
If you restore the old database after installing you WILL get problems

Frodo

gibman · 2007-02-22, 13:39

I use MS SQL server 2005.

Stop the TVservice.

Log into the database by using "MS SQL server management studio express".

It asks for user credentials. Log in

Now expand the databases tree.
Now u should see the tvlibrary database.
Right click and select tasks->backup.
From there on it should be obvious.

When u have to restore, just delete the "faulty" tvlib DB.
U do this by right clicking on it, and selecting "delete".
Once deleted, u can now restore the backup copy.

Right click on the databases tree and choose"restore database".

Start the TVservice.

That's it.

/Gibman

defcon5 · 2007-02-23, 09:44

Quote:

Originally Posted by gibman

I use MS SQL server 2005.

Stop the TVservice.

Log into the database by using "MS SQL server management studio express".

It asks for user credentials. Log in

Now expand the databases tree.
Now u should see the tvlibrary database.
Right click and select tasks->backup.
From there on it should be obvious.

When u have to restore, just delete the "faulty" tvlib DB.
U do this by right clicking on it, and selecting "delete".
Once deleted, u can now restore the backup copy.

Right click on the databases tree and choose"restore database".

Start the TVservice.

That's it.

/Gibman

Thanks Gibman, but.......

@Frodo

After read procedure of Gibman
What´s your opinion about this procedure?
Are you thinking is bad idea?

gibman · 2007-02-23, 09:54

It's always a good thing to know how to backup a database.
It might be useful in other situations than when installing new builds of the TVserver.

ex. if you want to play around with some stuff in the tvsetup app. and you want to make sure that you can undo changes. Then it's a good idea.

I also mentioned previously that sometimes it's a bad idea to restore an "older" backup of the DB on a new build of the tvserver.
New fields might have been added to one or more tables. The scheme might have changed.

The worst thing that will happen is that you will get some weird errors.
In this case, you will have to let it erase/reset your database.

I did get some DB resets when doing a newer SVN install.
I was lazy, so I restored the DB, and the new SVN kept on working ever since.
I think sometimes the tvserver just resets the DB for no reason.
Otherwise why would my restore work ?

It's worth a shot I think.

/Gibman

2007-02-21, 13:23	#1 (permalink)
mpfrank Portal Member Join Date: Nov 2006 Location: Cologne Posts: 186 Thanks: 10 Thanked 0 Times in 0 Posts Country: My System	How to preserve channel list and channel group setting when updating TV Server Hi guys, I'm testing the new TVServer with latest svn builds of MP. Everytime I update the TVServer I have to scan again for the channels (because channel lists are empty in TVServer config) and have to build my channel groups and sorting from scratch. As I am using DVB-S I receive around 800 channels and it's a hard and stupid work to put them again in order, building my own groups and map the channels to these individual groups. Is there a way how to preserve these setting, may be by exporting before updating and importing after updating? Thanks & cheers mpFrank

2007-02-22, 13:24	#6 (permalink)
defcon5 Portal Member Join Date: Apr 2006 Location: Barcelona (Catalonia) Age: 45 Posts: 155 Thanks: 0 Thanked 1 Time in 1 Post My System	Interesting Gibman Could you explain how can we do a channel list backup from SQL database? I use Import/export option only __________________ Defcon5 (Barcelona) ---------------------- Together, We will improve MP

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
Problem creating my own channel group	claudio_l2005	0.2.0.0 Release Candidate 3 Release and CVS Bugs	2	2006-03-29 00:06
How to set default channel group	simmo	General Support	0	2006-03-02 20:11
Channel Group change doesn't take effect immediately	htpcoz	The old Bugreport Forum	1	2005-11-19 12:15
Change Channel using F7/F8 Changes Group, not channel	Anonymous	General Support	2	2005-11-04 17:30
EPG Grab by Channel Group	infinityloop	Improvement Suggestions	1	2005-04-24 13:29

2007-02-21, 13:33	#2 (permalink)
regeszter Portal Member Join Date: Oct 2005 Location: Hungary Age: 33 Posts: 323 Thanks: 18 Thanked 3 Times in 3 Posts Country: My System	there is a channel export/import function in tvsetup

2007-02-21, 13:34	#3 (permalink)
gibman Portal Developer Join Date: Oct 2006 Location: Aarhus Posts: 741 Thanks: 4 Thanked 75 Times in 52 Posts Country: My System	I did the same painful experience. Spending hours on grouping things renaming channels etc. I did several tvserver SVN updates until one day the database was reset. All my channels and stuff were gone. Now I am doing a backup of the tvlibrary database making restores possible. U might get into trouble if the database schema is altered. Ex. a new field is added to a table. But it's better than nothing. I guess it's the price we pay for testing the latest and greatest SVN builds. /Gibman

2007-02-21, 19:57	#5 (permalink)
gibman Portal Developer Join Date: Oct 2006 Location: Aarhus Posts: 741 Thanks: 4 Thanked 75 Times in 52 Posts Country: My System	Then just do the backup of the tvlibrary database before installing a new SVN build. Then restore the database if the new SVN build has dropped/recreated all your tables (channels and groups). /Gibman

2007-02-22, 13:39	#8 (permalink)
gibman Portal Developer Join Date: Oct 2006 Location: Aarhus Posts: 741 Thanks: 4 Thanked 75 Times in 52 Posts Country: My System	I use MS SQL server 2005. Stop the TVservice. Log into the database by using "MS SQL server management studio express". It asks for user credentials. Log in Now expand the databases tree. Now u should see the tvlibrary database. Right click and select tasks->backup. From there on it should be obvious. When u have to restore, just delete the "faulty" tvlib DB. U do this by right clicking on it, and selecting "delete". Once deleted, u can now restore the backup copy. Right click on the databases tree and choose"restore database". Start the TVservice. That's it. /Gibman

2007-02-23, 09:54	#10 (permalink)
gibman Portal Developer Join Date: Oct 2006 Location: Aarhus Posts: 741 Thanks: 4 Thanked 75 Times in 52 Posts Country: My System	It's always a good thing to know how to backup a database. It might be useful in other situations than when installing new builds of the TVserver. ex. if you want to play around with some stuff in the tvsetup app. and you want to make sure that you can undo changes. Then it's a good idea. I also mentioned previously that sometimes it's a bad idea to restore an "older" backup of the DB on a new build of the tvserver. New fields might have been added to one or more tables. The scheme might have changed. The worst thing that will happen is that you will get some weird errors. In this case, you will have to let it erase/reset your database. I did get some DB resets when doing a newer SVN install. I was lazy, so I restored the DB, and the new SVN kept on working ever since. I think sometimes the tvserver just resets the DB for no reason. Otherwise why would my restore work ? It's worth a shot I think. /Gibman