Reply to thread

Message

<blockquote data-quote="azzuro" data-source="post: 966326" data-attributes="member: 50482">i have found this : <a href="https://forum.team-mediaportal.com/threads/suggestion-for-mysql-to-switch-to-innodb-from-myisam.88493/" target="_blank">https://forum.team-mediaportal.com/threads/suggestion-for-mysql-to-switch-to-innodb-from-myisam.88493/</a>[code]ALTER TABLE canceledschedule&nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB;ALTER TABLE card&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB;ALTER TABLE cardgroup&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB;ALTER TABLE cardgroupmap&nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB;ALTER TABLE channel&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB;ALTER TABLE channelgroup&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB;ALTER TABLE channellinkagemap&nbsp; &nbsp; &nbsp; ENGINE=InnoDB;ALTER TABLE channelmap&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB;ALTER TABLE conflict&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB;ALTER TABLE diseqcmotor&nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB;ALTER TABLE favorite&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB;ALTER TABLE groupmap&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB;ALTER TABLE history&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB;ALTER TABLE keyword&nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB;ALTER TABLE keywordmap&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB;ALTER TABLE personaltvguidemap&nbsp; ENGINE=InnoDB;ALTER TABLE program&nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB;ALTER TABLE radiochannelgroup&nbsp; &nbsp; &nbsp; ENGINE=InnoDB;ALTER TABLE radiogroupmap&nbsp; &nbsp; &nbsp; ENGINE=InnoDB;ALTER TABLE recording&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB;ALTER TABLE satellite&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB;ALTER TABLE schedule&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB;ALTER TABLE server&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB;ALTER TABLE setting&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB;ALTER TABLE timespan&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB;ALTER TABLE tuningdetail&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB;ALTER TABLE tvmoviemapping&nbsp; &nbsp; &nbsp; ENGINE=InnoDB;ALTER TABLE version&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB;[/code]&nbsp;[code]repair table canceledschedule;&nbsp; &nbsp; &nbsp; ALTER TABLE canceledschedule&nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB;repair table card;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ALTER TABLE card&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB;repair table cardgroup;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ALTER TABLE cardgroup&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB;repair table cardgroupmap;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ALTER TABLE cardgroupmap&nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB;repair table channel;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ALTER TABLE channel&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB;repair table channelgroup;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ALTER TABLE channelgroup&nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB;repair table channellinkagemap;&nbsp; &nbsp; &nbsp; ALTER TABLE channellinkagemap&nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB;repair table channelmap;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ALTER TABLE channelmap&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB;repair table conflict;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ALTER TABLE conflict&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB;repair table diseqcmotor;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ALTER TABLE diseqcmotor&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB;repair table favorite;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ALTER TABLE favorite&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB;repair table groupmap;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ALTER TABLE groupmap&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB;repair table history;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ALTER TABLE history&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB;repair table keyword;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ALTER TABLE keyword&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB;repair table keywordmap;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ALTER TABLE keywordmap&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB;repair table pendingdeletion;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ALTER TABLE pendingdeletion&nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB;repair table personaltvguidemap;&nbsp; &nbsp; &nbsp; ALTER TABLE personaltvguidemap&nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB;repair table program;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ALTER TABLE program&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB;repair table radiochannelgroup;&nbsp; &nbsp; &nbsp; ALTER TABLE radiochannelgroup&nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB;repair table radiogroupmap;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ALTER TABLE radiogroupmap&nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB;repair table recording;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ALTER TABLE recording&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB;repair table satellite;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ALTER TABLE satellite&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB;repair table schedule;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ALTER TABLE schedule&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB;repair table server;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ALTER TABLE server&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB;repair table setting;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ALTER TABLE setting&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB;repair table softwareencoder;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ALTER TABLE softwareencoder&nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB;repair table timespan;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ALTER TABLE timespan&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB;repair table tuningdetail;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ALTER TABLE tuningdetail&nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB;repair table tvmoviemapping;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ALTER TABLE tvmoviemapping&nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB;repair table version;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ALTER TABLE version&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB;[/code]&nbsp;An other Topic :link of this code : by @<a href="https://forum.team-mediaportal.com/members/vasilich.97516/" target="_blank">Vasilich</a>[code]ALTER TABLE version&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE tvmoviemapping&nbsp; &nbsp; ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE tuningdetail&nbsp; &nbsp; &nbsp; ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE timespan&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE softwareencoder&nbsp; &nbsp; ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE setting&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE server&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE schedule&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE satellite&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE recording&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE radiogroupmap&nbsp; &nbsp; &nbsp; ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE radiochannelgroup&nbsp; ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE program&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE personaltvguidemap ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE pendingdeletion&nbsp; &nbsp; ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE keywordmap&nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE keyword&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE history&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE groupmap&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE favorite&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE diseqcmotor&nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE conflict&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE channelmap&nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE channellinkagemap&nbsp; ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE channelgroup&nbsp; &nbsp; &nbsp; ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE channel&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE cardgroupmap&nbsp; &nbsp; &nbsp; ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE cardgroup&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE card&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE canceledschedule&nbsp; ENGINE=InnoDB ROW_FORMAT=COMPACT;[/code]</blockquote>

[QUOTE="azzuro, post: 966326, member: 50482"] i have found this : [url]https://forum.team-mediaportal.com/threads/suggestion-for-mysql-to-switch-to-innodb-from-myisam.88493/[/url] [code]ALTER TABLE canceledschedule ENGINE=InnoDB; ALTER TABLE card ENGINE=InnoDB; ALTER TABLE cardgroup ENGINE=InnoDB; ALTER TABLE cardgroupmap ENGINE=InnoDB; ALTER TABLE channel ENGINE=InnoDB; ALTER TABLE channelgroup ENGINE=InnoDB; ALTER TABLE channellinkagemap ENGINE=InnoDB; ALTER TABLE channelmap ENGINE=InnoDB; ALTER TABLE conflict ENGINE=InnoDB; ALTER TABLE diseqcmotor ENGINE=InnoDB; ALTER TABLE favorite ENGINE=InnoDB; ALTER TABLE groupmap ENGINE=InnoDB; ALTER TABLE history ENGINE=InnoDB; ALTER TABLE keyword ENGINE=InnoDB; ALTER TABLE keywordmap ENGINE=InnoDB; ALTER TABLE personaltvguidemap ENGINE=InnoDB; ALTER TABLE program ENGINE=InnoDB; ALTER TABLE radiochannelgroup ENGINE=InnoDB; ALTER TABLE radiogroupmap ENGINE=InnoDB; ALTER TABLE recording ENGINE=InnoDB; ALTER TABLE satellite ENGINE=InnoDB; ALTER TABLE schedule ENGINE=InnoDB; ALTER TABLE server ENGINE=InnoDB; ALTER TABLE setting ENGINE=InnoDB; ALTER TABLE timespan ENGINE=InnoDB; ALTER TABLE tuningdetail ENGINE=InnoDB; ALTER TABLE tvmoviemapping ENGINE=InnoDB; ALTER TABLE version ENGINE=InnoDB;[/code] [code]repair table canceledschedule; ALTER TABLE canceledschedule ENGINE=InnoDB; repair table card; ALTER TABLE card ENGINE=InnoDB; repair table cardgroup; ALTER TABLE cardgroup ENGINE=InnoDB; repair table cardgroupmap; ALTER TABLE cardgroupmap ENGINE=InnoDB; repair table channel; ALTER TABLE channel ENGINE=InnoDB; repair table channelgroup; ALTER TABLE channelgroup ENGINE=InnoDB; repair table channellinkagemap; ALTER TABLE channellinkagemap ENGINE=InnoDB; repair table channelmap; ALTER TABLE channelmap ENGINE=InnoDB; repair table conflict; ALTER TABLE conflict ENGINE=InnoDB; repair table diseqcmotor; ALTER TABLE diseqcmotor ENGINE=InnoDB; repair table favorite; ALTER TABLE favorite ENGINE=InnoDB; repair table groupmap; ALTER TABLE groupmap ENGINE=InnoDB; repair table history; ALTER TABLE history ENGINE=InnoDB; repair table keyword; ALTER TABLE keyword ENGINE=InnoDB; repair table keywordmap; ALTER TABLE keywordmap ENGINE=InnoDB; repair table pendingdeletion; ALTER TABLE pendingdeletion ENGINE=InnoDB; repair table personaltvguidemap; ALTER TABLE personaltvguidemap ENGINE=InnoDB; repair table program; ALTER TABLE program ENGINE=InnoDB; repair table radiochannelgroup; ALTER TABLE radiochannelgroup ENGINE=InnoDB; repair table radiogroupmap; ALTER TABLE radiogroupmap ENGINE=InnoDB; repair table recording; ALTER TABLE recording ENGINE=InnoDB; repair table satellite; ALTER TABLE satellite ENGINE=InnoDB; repair table schedule; ALTER TABLE schedule ENGINE=InnoDB; repair table server; ALTER TABLE server ENGINE=InnoDB; repair table setting; ALTER TABLE setting ENGINE=InnoDB; repair table softwareencoder; ALTER TABLE softwareencoder ENGINE=InnoDB; repair table timespan; ALTER TABLE timespan ENGINE=InnoDB; repair table tuningdetail; ALTER TABLE tuningdetail ENGINE=InnoDB; repair table tvmoviemapping; ALTER TABLE tvmoviemapping ENGINE=InnoDB; repair table version; ALTER TABLE version ENGINE=InnoDB;[/code] An other Topic : link of this code : by @[URL='https://forum.team-mediaportal.com/members/vasilich.97516/']Vasilich[/URL] [code]ALTER TABLE version ENGINE=InnoDB ROW_FORMAT=COMPACT; ALTER TABLE tvmoviemapping ENGINE=InnoDB ROW_FORMAT=COMPACT; ALTER TABLE tuningdetail ENGINE=InnoDB ROW_FORMAT=COMPACT; ALTER TABLE timespan ENGINE=InnoDB ROW_FORMAT=COMPACT; ALTER TABLE softwareencoder ENGINE=InnoDB ROW_FORMAT=COMPACT; ALTER TABLE setting ENGINE=InnoDB ROW_FORMAT=COMPACT; ALTER TABLE server ENGINE=InnoDB ROW_FORMAT=COMPACT; ALTER TABLE schedule ENGINE=InnoDB ROW_FORMAT=COMPACT; ALTER TABLE satellite ENGINE=InnoDB ROW_FORMAT=COMPACT; ALTER TABLE recording ENGINE=InnoDB ROW_FORMAT=COMPACT; ALTER TABLE radiogroupmap ENGINE=InnoDB ROW_FORMAT=COMPACT; ALTER TABLE radiochannelgroup ENGINE=InnoDB ROW_FORMAT=COMPACT; ALTER TABLE program ENGINE=InnoDB ROW_FORMAT=COMPACT; ALTER TABLE personaltvguidemap ENGINE=InnoDB ROW_FORMAT=COMPACT; ALTER TABLE pendingdeletion ENGINE=InnoDB ROW_FORMAT=COMPACT; ALTER TABLE keywordmap ENGINE=InnoDB ROW_FORMAT=COMPACT; ALTER TABLE keyword ENGINE=InnoDB ROW_FORMAT=COMPACT; ALTER TABLE history ENGINE=InnoDB ROW_FORMAT=COMPACT; ALTER TABLE groupmap ENGINE=InnoDB ROW_FORMAT=COMPACT; ALTER TABLE favorite ENGINE=InnoDB ROW_FORMAT=COMPACT; ALTER TABLE diseqcmotor ENGINE=InnoDB ROW_FORMAT=COMPACT; ALTER TABLE conflict ENGINE=InnoDB ROW_FORMAT=COMPACT; ALTER TABLE channelmap ENGINE=InnoDB ROW_FORMAT=COMPACT; ALTER TABLE channellinkagemap ENGINE=InnoDB ROW_FORMAT=COMPACT; ALTER TABLE channelgroup ENGINE=InnoDB ROW_FORMAT=COMPACT; ALTER TABLE channel ENGINE=InnoDB ROW_FORMAT=COMPACT; ALTER TABLE cardgroupmap ENGINE=InnoDB ROW_FORMAT=COMPACT; ALTER TABLE cardgroup ENGINE=InnoDB ROW_FORMAT=COMPACT; ALTER TABLE card ENGINE=InnoDB ROW_FORMAT=COMPACT; ALTER TABLE canceledschedule ENGINE=InnoDB ROW_FORMAT=COMPACT;[/code] [/QUOTE]

Verification