Reply to thread

Message

Thx for your response.

I can't confirm this.

I did the following:

[code]-do a backup with huhas Backup plugin
-remove 1.30 beta + TV-server completely
-uninstall MySQL 5.1
-install MySQL 5.6
-install 1.30RC and choose the option "I do already have a database-server"
Here I had some trouble.
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.
-restore my backup
I had a little problem here also. After the restore all TV-channels now have channel number 10000
[/code]

First I thought, that everything was ok. The database default engine was set to InnoDB. But the I have mentioned that all the tables where created as MyISAM tables.

That I wanted to alter the tables with no luck with recording and schedule table ...

When you have a look to your 5.6 DB what does the describe of the tables say? The same as mine said?

<blockquote data-quote="megahorst" data-source="post: 970412" data-attributes="member: 22213">Thx for your response.&nbsp;&nbsp;&nbsp;I can't confirm this.&nbsp;I did the following:&nbsp;[code]-do a backup with huhas Backup plugin-remove 1.30 beta + TV-server completely-uninstall MySQL 5.1-install MySQL 5.6-install 1.30RC and choose the option &quot;I do already have a database-server&quot;Here I had some trouble.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 &quot;give propper IP or hostname&quot;At this point I had to go back to MySQL workbench and had to add a user/hostname combination &quot;root / &lt;full hostname of htpc&gt;&quot; and to give DBA rights to this user.After this the MePo installer created all MePo tables in the MySQL 5.6 DB.-restore my backupI had a little problem here also. After the restore all TV-channels now have channel number 10000[/code]&nbsp;First I thought, that everything was ok. The database default engine was set to InnoDB. But the I have mentioned that all the tables where created as MyISAM tables.&nbsp;That I wanted to alter the tables with no luck with recording and schedule table ...&nbsp;When you have a look to your 5.6 DB what does the describe of the tables say? The same as mine said?</blockquote>

[QUOTE="megahorst, post: 970412, member: 22213"] Thx for your response. I can't confirm this. I did the following: [code]-do a backup with huhas Backup plugin -remove 1.30 beta + TV-server completely -uninstall MySQL 5.1 -install MySQL 5.6 -install 1.30RC and choose the option "I do already have a database-server" Here I had some trouble. 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. -restore my backup I had a little problem here also. After the restore all TV-channels now have channel number 10000 [/code] First I thought, that everything was ok. The database default engine was set to InnoDB. But the I have mentioned that all the tables where created as MyISAM tables. That I wanted to alter the tables with no luck with recording and schedule table ... When you have a look to your 5.6 DB what does the describe of the tables say? The same as mine said? [/QUOTE]