Update MySQL 5.1 to latest 5.6 version (2 Viewers)

[megahorst]

You have to give the full name as host. Hoschi-PC.fritz.box.
This should do the job.

 

[MaxMan23]

no....

 

[megahorst]

no....

View attachment 142055

My fault ...
I sholuld have described it in more detail:

I meant not in the workbench. There % is OK!
You have to give it as hostname in the connection settings of the MePo Config

 

[MaxMan23]

like this...?

 

[megahorst]

I have managesd it like I have described it here:
https://forum.team-mediaportal.com/threads/how-to-user-exp-update-mysql.116108/page-2#post-964125

install 1.30RC and choose the option "I do already have a database-server"
Here I had some trouble again.
During installation I was asked for the database connection attributes. The installer did not accept 127.0.0.1 or localhost as address of the server that hosts the database. It always said "give propper IP or hostname"
At this point I had to go back to MySQL workbench and had to add a user/hostname combination "root / <full hostname of htpc>" and to give DBA rights to this user.
After this the MePo installer created all MePo tables in the MySQL 5.6 DB.

You have given DBA rights to the new created user?

 

[MaxMan23]

That was it

Thanks to all and a Happy New Year

 

[D3ltoroxp]

So here we continued. Here the sql file for regeszter. Sorry i forgott to make zip.

http://www.file-upload.net/download-8476879/mptvdb.sql.html

 

[regeszter]

The file seems to be OK. I will test in my test db.

EDIT:
After import:

mysql> SELECT `TABLE_NAME`, `ENGINE` FROM `information_schema`.`TABLES` WHERE `T
ABLE_SCHEMA` = 'mptvdb';
+--------------------+--------+
| TABLE_NAME | ENGINE |
+--------------------+--------+
| canceledschedule | InnoDB |
| card | InnoDB |
| cardgroup | InnoDB |
| cardgroupmap | InnoDB |
| channel | InnoDB |
| channelgroup | InnoDB |
| channellinkagemap | InnoDB |
| channelmap | InnoDB |
| conflict | InnoDB |
| diseqcmotor | InnoDB |
| favorite | InnoDB |
| groupmap | InnoDB |
| history | InnoDB |
| keyword | InnoDB |
| keywordmap | InnoDB |
| pendingdeletion | InnoDB |
| personaltvguidemap | InnoDB |
| program | InnoDB |
| radiochannelgroup | InnoDB |
| radiogroupmap | InnoDB |
| recording | InnoDB |
| satellite | InnoDB |
| schedule | InnoDB |
| server | InnoDB |
| setting | InnoDB |
| softwareencoder | InnoDB |
| timespan | InnoDB |
| tuningdetail | InnoDB |
| tvmoviemapping | InnoDB |
| version | InnoDB |
+--------------------+--------+
30 rows in set (0.09 sec)

Can you re-run the import again?

 

[D3ltoroxp]

K thank you. Yes i can do it thirt time. Maybe this was my fault.. I typed that

SELECT `TABLE_NAME`, `ENGINE` FROM `information_schema`.`TABLES` WHERE `T
ABLE_SCHEMA` = 'mptvdb';

in my CMD. You add this on start at the line

mysql>

Try again and the same result. After the imput line there is no message if was right or wrong.

I can do what i want, it does not work. I think on this part i import it back to mysql...

 

[D3ltoroxp]

So all tables are using now InnoDB engine (make with workbench easily) but 2 can't alter table shedule and records becaus this message...

Specified key was too long; max key length is 767 bytesSQL

Here in the forum i have found a info the someone like this

For what it's worth, i just had the same problem and switching from utf8_general_ci to utf8_unicode_ci solved the problem for me. I do not know why though

Is this needed utf8_general_ci or can i choose the other one ?

What we need RAW FORMAT : Dynamic or Compact: When i do a fresh install with M 1.6 and install mysql 5.6 and make a dump of mptvdb.sql there is also RAW Format Dynamic. But around the forums some people talk from Compact Format ? What is right ?