Lost configuration after database upgrade (during upgrade to 1.8) (2 Viewers)

[alexeix]

Hi,

I've upgraded from 1.6 to 1.8 and everything seemed to complete correctly, however, I then got a prompt to upgrade MYSQL from 5.1 to 5.6 (from memory), so I went ahead.
As a result, I have lost the mappings to all my channels and all my existing recordings.
I don't want to re-run the set-up if I can help it, since it took a really long time just scanning the channels and I also don't know if I would need to completely reconfigure it.
Setting it up 'just right' took a lot of effort.

Can anyone advise if they is a way to restore my previous settings?
I didn't back up my configuration prior to the upgrade, but does the upgrade wizard or the MYSQL upgrade tool create any kind of settings backup?

Any help appreciated!

 

[Sebastiii]

Could you post full log (debug) ?
Like this someone can look @ it and maybe find something

 

[alexeix]

Could you post full log (debug) ?
Like this someone can look @ it and maybe find something

Can you confirm exactly where to get the log file/s?
I can see log folders in the Media Portal and TV Server folders.
I also have folders for the old log files, which is probably where I need to get the files, since I tried a reinstall of 1.8 after I found the problem.
It didn't solve it, but I suspect the log files I need are now in the old folder.

Can you point me to the right place please?
Thanks!

 

[Sebastiii]

Look @ signature to how get log all is explained in wiki thanks.

 

[alexeix]

Here you go...

So, are the configuration settings, channels and recordings database saved anywhere (prior to the upgrade)?

 

[Sebastiii]

Hard to say from log but thanks anyway

The build i have created to remove innodb change was deleted but it will not solve your issue.
Normally your old db are on your hard disk, it should be in :
C:\ProgramData\MySQL\MySQL Server 5.1\data

The new one should be :
C:\ProgramData\MySQL\MySQL Server 5.6\data

So, we need to know if you are on 5.6 or 5.1.
You can also try to copy your db from MySQL Server 5.1\data to MySQL Server 5.6\data (normal db schema is 'mptvdb'

We can also try to uninstall MySQL 5.6 and reinstall older mp version that contain 5.1 but it will be hard to do if you don't know what is needed exactly.

For sure, try to copy both data folder somewhere to have a backup

 

[Sebastiii]

I have open a Jira and created a branch (i will put the link to the installer on Jira when build will finish)
https://issues.team-mediaportal.com/browse/MP1-4572

So you can try to reinstall with this build first and see what happen

 

[Sebastiii]

Link to installer added

 

[alexeix]

Thanks for your help with this problem!
I'm now on 5.6 (as per original post, the issue only arose because I went along with the upgrade prompts), but having checked
C:\ProgramData\MySQL\MySQL Server 5.1\data, I do indeed still have data there.

So, can you clarify exactly which files/folders I need to copy across to the 5.6 folder?

Do I then need to run the installer you linked to?

Finally, is this a development build and if so, where do I stand on future upgrades?
Cheers!

 

[Sebastiii]

Hi,

You can upgrade or select reinstall with newer version.
On my side i would to backup both folder 5.1 and 5.6.

Copy mptvdb folder from 'C:\ProgramData\MySQL\MySQL Server 5.1\data' to 'C:\ProgramData\MySQL\MySQL Server 5.6\data'

Try and see if it works, if don't, i think you need to manually uninstall MySQL from 'program and feature' and use MP installer to reinstall it.