How to preserve channel list and channel group setting when updating TV Server (2 Viewers)

[mpfrank]

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]

there is a channel export/import function in tvsetup

 

[gibman]

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]

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.

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]

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]

Interesting Gibman

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

 

[Frodo]

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]

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]

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]

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