Reply to thread

i have found this : https://forum.team-mediaportal.com/threads/suggestion-for-mysql-to-switch-to-innodb-from-myisam.88493/

[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 @Vasilich

[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]


Top Bottom