M
Hi if the recovery command doesn't work, the table may have many millions of records and that's why the command delay.If the recovery does not work, you can remove the table and create it again, then the information is recovered from the Master.csv.CREATE TABLE IF NOT EXISTS `asterisk`.`cdr` (
`id` INT ZEROFILL NOT NULL AUTO_INCREMENT,
`calldate` DATETIME NOT NULL DEFAULT '2011-01-01 00:00:00',
`org_unique_id` VARCHAR(255) NULL,
`uniqueid` VARCHAR(32) NOT NULL DEFAULT '',
`clid` VARCHAR(80) NOT NULL DEFAULT '',
`src` VARCHAR(80) NOT NULL DEFAULT '',
`dst` VARCHAR(80) NOT NULL DEFAULT '',
`dcontext` VARCHAR(80) NOT NULL DEFAULT '',
`channel` VARCHAR(80) NOT NULL DEFAULT '',
`dstchannel` VARCHAR(80) NOT NULL DEFAULT '',
`lastapp` VARCHAR(80) NOT NULL DEFAULT '',
`lastdata` VARCHAR(80) NOT NULL DEFAULT '',
`duration` INT(11) NOT NULL DEFAULT '0',
`billsec` INT(11) NOT NULL DEFAULT '0',
`disposition` VARCHAR(45) NULL DEFAULT '',
`amaflags` INT(11) NULL DEFAULT '0',
`accountcode` VARCHAR(20) NULL DEFAULT '',
`userfield` VARCHAR(255) NULL DEFAULT '',
`id_huesped` INT NULL,
`id_troncal` INT NULL,
`endcall` DATETIME NULL,
`id_ruta_saliente` INT NULL,
`id_ruta_entrante` INT NULL,
`linkedid` VARCHAR(40) NULL,
`sentido` TINYINT(5) NULL,
`robot` TINYINT(1) NULL DEFAULT 0,
`procesada` TINYINT(1) NULL DEFAULT 0,
`grabacion` VARCHAR(255) NULL,
`desborde` INT NULL COMMENT '1 - Buzon\n2 - Numero interno\n3 - Numero externo.',
INDEX `calldate` (`calldate` ASC),
INDEX `dst` (`dst` ASC),
INDEX `accountcode` (`accountcode` ASC),
INDEX `uniqueid` (`uniqueid` ASC),
PRIMARY KEY (`id`),
INDEX `ix_lastapp` (`lastapp` ASC),
INDEX `ix_orguid` (`org_unique_id` ASC),
INDEX `ix_grabacion` (`userfield` ASC))
ENGINE = MyISAM
DEFAULT CHARACTER SET = latin1
After that you must do the actions corresponding to the recovery of the information using the DYALOGO tools.
