home
products
contribute
download
documentation
forum
Home
Forums
New posts
Search forums
What's new
New posts
All posts
Latest activity
Members
Registered members
Current visitors
Donate
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Search titles only
By:
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
MediaPortal 1
Support
Installation, configuration support
Upgrade of 1.5 with 1.6 does not upgrade MySQL 5.1 to 5.6
Contact us
RSS
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="mrspock" data-source="post: 1052515" data-attributes="member: 82522"><p>I got it updated, but it was harder than expected. These are the steps I followed (based on manual installation from <a href="https://forum.team-mediaportal.com/threads/mediaportal-1-6-0-pre-release-ready-for-download.122865/page-2#post-1041540" target="_blank"><u>Manual update</u></a>):</p><ol> <li data-xf-list-type="ol">Upgrade to MP 1.6. </li> <li data-xf-list-type="ol">Use the import/export section of TV Server configuration to export all your channels, etc.</li> <li data-xf-list-type="ol">Stop the TV service and ensure TV Server configuration is closed. [<em>I also stopped MySQL service</em>]</li> <li data-xf-list-type="ol">Uninstall MySQL. [<em>from Windows control panel</em>]</li> <li data-xf-list-type="ol">Install MySQL 5.6. Make sure to remember the root username and password that you use for step 9.<ol> <li data-xf-list-type="ol"><em>Download from </em><a href="http://dev.mysql.com/downloads/mysql/" target="_blank"><em>http://dev.mysql.com/downloads/mysql/</em></a><em>, Platform Windows, MySQL installer MSI (it is for both 32-64 bits windows)</em></li> <li data-xf-list-type="ol"><em>Run installer</em></li> <li data-xf-list-type="ol"><em>Select type Server only</em></li> <li data-xf-list-type="ol"><em>Keep the following options by default</em></li> <li data-xf-list-type="ol"><em>When asked for the root password, type MediaPortal (case is important)</em></li> <li data-xf-list-type="ol"><em>Restart computer</em></li> </ol></li> <li data-xf-list-type="ol">Right click the TV Server configuration shortcut on your desktop and select "properties".</li> <li data-xf-list-type="ol">Change the "target" from ...\SetupTv.exe" to ...SetupTv.exe" /configure-db ... (note that the quotation marks are important).</li> <li data-xf-list-type="ol">Double click on the shortcut. You should now see the database connection popup that you would have seen when you first installed. All the fields should be set with your current database connection parameters.</li> <li data-xf-list-type="ol">Configure username and password for the new MySQL 5.6 database. Using the root user is easiest. You can use a different user account if you want, but that requires extra configuration in MySQL which is beyond the scope of this post. [<em>Nothing to change, if used MediaPortal password on root</em>]</li> <li data-xf-list-type="ol">Click "test" and then "save".<ol> <li data-xf-list-type="ol"><em>If test fails (mine failed because it was unable to connect to my PC), download MySQL Workbench MSI installer from </em><a href="http://dev.mysql.com/downloads/tools/workbench/" target="_blank"><em>http://dev.mysql.com/downloads/tools/workbench/</em></a></li> <li data-xf-list-type="ol"><em>Run installer (default options)</em></li> <li data-xf-list-type="ol"><em>Run MySQL Workbench</em></li> <li data-xf-list-type="ol"><em>Double click the grey box "Local Instance MySQL5.6, root..." at the top left corner</em></li> <li data-xf-list-type="ol"><em>Type the MediaPortal password when asked (check to remember it)</em></li> <li data-xf-list-type="ol"><em>Click on Users and privileges (on the left)</em></li> <li data-xf-list-type="ol"><em>Select user root from host ::1</em></li> <li data-xf-list-type="ol"><em>Change ::1 into % in the Limit connections box</em></li> <li data-xf-list-type="ol"><em>Click the apply button at the bottom</em></li> <li data-xf-list-type="ol"><em>Go back to TV server configuration and click "test" again. It worked for me. Click "save"</em></li> <li data-xf-list-type="ol"><em>Restart computer</em></li> </ol></li> <li data-xf-list-type="ol">Right click the TV Server configuration shortcut on your desktop and select "properties".</li> <li data-xf-list-type="ol">Remove the configure-db section that you added.</li> <li data-xf-list-type="ol">Open TV Server configuration. [<em>confirm to run TV service if asked</em>]</li> <li data-xf-list-type="ol">Go to the import/export section.</li> <li data-xf-list-type="ol">Import the file exported in step 2.</li> </ol><p>But I noticed some configurations missing at TV Server configuration, so I had to manually modify (it would be nice to copy that before updating anything):</p><ul> <li data-xf-list-type="ul">TV servers deactivated and priorities</li> <li data-xf-list-type="ul">Recording, start and stop times</li> <li data-xf-list-type="ul">Recording, folders</li> <li data-xf-list-type="ul">Timeshift, folders</li> <li data-xf-list-type="ul">Timeshift, min, max, size</li> <li data-xf-list-type="ul">PowerScheduler, processes</li> </ul><p>Hope this could be useful to somebody. <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite24" alt="(y)" title="Thumbs Up (y)" loading="lazy" data-shortname="(y)" /></p></blockquote><p></p>
[QUOTE="mrspock, post: 1052515, member: 82522"] I got it updated, but it was harder than expected. These are the steps I followed (based on manual installation from [URL='https://forum.team-mediaportal.com/threads/mediaportal-1-6-0-pre-release-ready-for-download.122865/page-2#post-1041540'][U]Manual update[/U][/URL]): [LIST=1] [*]Upgrade to MP 1.6. [*]Use the import/export section of TV Server configuration to export all your channels, etc. [*]Stop the TV service and ensure TV Server configuration is closed. [[I]I also stopped MySQL service[/I]] [*]Uninstall MySQL. [[I]from Windows control panel[/I]] [*]Install MySQL 5.6. Make sure to remember the root username and password that you use for step 9. [LIST=1] [*][I]Download from [/I][URL='http://dev.mysql.com/downloads/mysql/'][I]http://dev.mysql.com/downloads/mysql/[/I][/URL][I], Platform Windows, MySQL installer MSI (it is for both 32-64 bits windows)[/I] [*][I]Run installer[/I] [*][I]Select type Server only[/I] [*][I]Keep the following options by default[/I] [*][I]When asked for the root password, type MediaPortal (case is important)[/I] [*][I]Restart computer[/I] [/LIST] [*]Right click the TV Server configuration shortcut on your desktop and select "properties". [*]Change the "target" from ...\SetupTv.exe" to ...SetupTv.exe" /configure-db ... (note that the quotation marks are important). [*]Double click on the shortcut. You should now see the database connection popup that you would have seen when you first installed. All the fields should be set with your current database connection parameters. [*]Configure username and password for the new MySQL 5.6 database. Using the root user is easiest. You can use a different user account if you want, but that requires extra configuration in MySQL which is beyond the scope of this post. [[I]Nothing to change, if used MediaPortal password on root[/I]] [*]Click "test" and then "save". [LIST=1] [*][I]If test fails (mine failed because it was unable to connect to my PC), download MySQL Workbench MSI installer from [/I][URL='http://dev.mysql.com/downloads/tools/workbench/'][I]http://dev.mysql.com/downloads/tools/workbench/[/I][/URL] [*][I]Run installer (default options)[/I] [*][I]Run MySQL Workbench[/I] [*][I]Double click the grey box "Local Instance MySQL5.6, root..." at the top left corner[/I] [*][I]Type the MediaPortal password when asked (check to remember it)[/I] [*][I]Click on Users and privileges (on the left)[/I] [*][I]Select user root from host ::1[/I] [*][I]Change ::1 into % in the Limit connections box[/I] [*][I]Click the apply button at the bottom[/I] [*][I]Go back to TV server configuration and click "test" again. It worked for me. Click "save"[/I] [*][I]Restart computer[/I] [/LIST] [*]Right click the TV Server configuration shortcut on your desktop and select "properties". [*]Remove the configure-db section that you added. [*]Open TV Server configuration. [[I]confirm to run TV service if asked[/I]] [*]Go to the import/export section. [*]Import the file exported in step 2. [/LIST] But I noticed some configurations missing at TV Server configuration, so I had to manually modify (it would be nice to copy that before updating anything): [LIST] [*]TV servers deactivated and priorities [*]Recording, start and stop times [*]Recording, folders [*]Timeshift, folders [*]Timeshift, min, max, size [*]PowerScheduler, processes [/LIST] Hope this could be useful to somebody. (y) [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
Support
Installation, configuration support
Upgrade of 1.5 with 1.6 does not upgrade MySQL 5.1 to 5.6
Contact us
RSS
Top
Bottom