Move local Mysql to Standalone SQL
I performed a backup of my ServiceDesk database to migrate to standalone server running MySql when I performed a restore I received the following error.
If anyone can provide help to resolve this it would be appreciated.
Error while executing this query:CREATE TABLE `slaescalation` (
`ESCALATIONID` bigint(20) NOT NULL default '0',
`SLAID` int(10) NOT NULL default '0',
`LEVEL` int(10) NOT NULL default '0',
`STATUS` tinyint(1) NOT NULL default '0',
`ESCALATETOID` bigint(19) NOT NULL default '0',
`ESCAFTERDAYS` int(10) NOT NULL default '0',
`ESCAFTERHOURS` int(10) NOT NULL default '0',
`ESCAFTERMINUTES` int(10) NOT NULL default '0',
`ESCTOTICKETOWNER` tinyint(1) default '0',
PRIMARY KEY (`ESCALATIONID`),
KEY `SLAEscalation_FK1_IDX` (`ESCALATETOID`),
KEY `SLAEscalation_FK2_IDX` (`SLAID`),
CONSTRAINT `SLAEscalation_FK1` FOREIGN KEY (`ESCALATETOID`) REFERENCES `escalatetomediator` (`ESCALATETOID`) ON DELETE SET NULL,
CONSTRAINT `SLAEscalation_FK2` FOREIGN KEY (`SLAID`) REFERENCES `sladefinition` (`SLAID`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
The server has returned this error message:Can't create table './servicedesk/slaescalation.frm' (errno: 150)
MySQL Error.
If anyone can provide help to resolve this it would be appreciated.