Update MySQL 5.1 to latest 5.6 version (3 Viewers)

[azzuro]

@regeszter : this code can help for create an archives files, who contain mysqldump exe + bat files, for an autodump.
http://support.severalnines.com/entries/24434706-Migrate-MyISAM-tables-to-INNODB-using-mysqldump

 

[regeszter]

@regeszter : this code can help for create an archives files, who contain mysqldump exe + bat files, for an autodump.
http://support.severalnines.com/entries/24434706-Migrate-MyISAM-tables-to-INNODB-using-mysqldump

It requires sed.

 

[azzuro]

It requires sed.

what is SED ?

 

[mm1352000]

http://en.wikipedia.org/wiki/Sed

 

[azzuro]

http://gnuwin32.sourceforge.net/packages/sed.htm
SED for windows lol

http://unxutils.sourceforge.net/

 

[azzuro]

is the full package with depedency.

 

[MaxMan23]

I have a connection problem after doing this steps:

1. Upgrade to MP 1.6 PR.
2. Use the import/export section of TV Server configuration to export all your channels etc.
3. Stop the TV service and ensure TV Server configuration is closed.
4. Uninstall MySQL.
5. Install MySQL 5.6. Make sure to remember the root username and password that you use for step 9.
6. Right click the TV Server configuration shortcut on your desktop and select "properties".
7. Change the "target" from ...\SetupTv.exe" to ...SetupTv.exe" /configure-db ... (note that the quotation marks are important).
8. 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.
9. 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.
10. Click "test" and then "save".
11. Right click the TV Server configuration shortcut on your desktop and select "properties".
12. Remove the configure-db section that you added.
13. Open TV Server configuration.
14. Go to the import/export section.
15. Import the file exported in step 2.

This process should give the best possible outcomes in terms of the database.


When i do step 10 i got an connection Error:

 

[Hawkeye]

See step 4 in this post.

 

[MaxMan23]

next Error...

(Pass is MediaPortal)

 

[MaxMan23]

After updating the mysql workbench i could add the user, but i got the same error...

(I also did a restart of my pc)