Migration help. (1 Viewer)

wjw

Portal Pro
July 13, 2008
342
32
United Kingdom United Kingdom
Country flag
Hi,
I have decided to replace my existing HTPC with a brand new system. My plan was to migrate all the data first - all done successfully - and then to migrate the MpTvDb from the old machine to the new one using the MySQL Workbench tool - again all worked fine.

Except that.....
TVServer now won't work properly because the TV cards are different and it fails to start/stop the database due to an error in getting the card. My assumption at this point is that this is because it's trying to load a card that doesn't exist on the new system.

Obviously I would like to preserve as much of the old database as possible, largely because it contains all the TVWishList data as well as preferred channel groups and so on, and doing this will save a very large amount of time in trying to rebuild several years of data.

Obviously one possible solution - I think! - would be to migrate all the tables except for those containing the card and tuning data. Once this is done I could then just rescan on the new cards.

Would this work OK? If so, can anyone tell me which are the tables I need to leave out of the migration process? The MySQL Workbench make this fairly easy to do once you know the specific tables to handle.
 

wjw

Portal Pro
July 13, 2008
342
32
United Kingdom United Kingdom
Country flag
As ever, many thanks for your help. I never thought of that one and it would have been a bit simpler! (eventually I guessed at the Card table and just truncated that - a restart repopulated that tale with the new configuration).

I have just re-done the migration and changed the Server name and everything is just perfect! I assume that I will need to rescan because these are new cards and will do that once I can get the new machine into place with access to the satellite cables.

Again, thanks for your advice and time.
 

wjw

Portal Pro
July 13, 2008
342
32
United Kingdom United Kingdom
Country flag
What a speedy service! Again, thanks - that will save a good chunk of time!
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

OP Similar threads Forum Replies Date
N Migrating from WMC Newcomers Forum 43
J How to migrate MP1 plugin to MP2? Plugin Development 1
P WMC on Windows 7 migrating to Media Portal on Windows 10 Newcomers Forum 5
H Database migration Archive 85
J Help with new grabber file. WebEPG 1
J IPTV Sweden, need help with m3u list MediaPortal 1 Plugins 14
wizard123 [solved] MP1 Build help MediaPortal 1 21
D Please help with getting Schedules Direct to work Newcomers Forum 10
U [solved] Beginner needs help recording live TV General 19
A IPTV from https m3u8 urls - Help General 6
mrmojo666 beginner: trying to write a plugin, need help to catch event General Development (no feature request here!) 3
M A little help with new install pls Installation, configuration support 3
N Music player help Listen Music 4
A Enigma2 receiver channels on Windows PC with Media Portal help General Support 0
A Help! MP2 - DVB-T Not recognised (DRIVERS?) General 12
milagroso Remote control with EventGhost - I'm stuck, need help General 3
D Font size reduced. help. Skins and Plugins Installer (MPEI) 0
S Gpu/hdtv/mp setup help please Newcomers Forum 3
W Need help getting my TV guide working again General Support 1
A I need help with 110 and 119 west Installation, configuration support 21
A Need help rescaning Channels for 110 and 119 west MediaPortal 1 Talk 2
C EPG-Buddy: so close to no help needed Electronic Program Guide 8
mjmapi Help, getting My TVSeries 16
F Setup Help General 1
Top Bottom