cannot import from backup file
since I upgrade from 1.0.6 to 1.1.1 server and have a little bug about non standard port connected ..
I want to used 1.0.6 but I cannot import data from backup file (phpMyadmin , webmin , navicat etc.) all import program that I used will show error on table media
Error at the line 330461: ) ENGINE=InnoDB AUTO_INCREMENT=143 DEFAULT CHARSET=utf8;
Query: CREATE TABLE `media` (
`mediaID` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
`type` varchar(10) NOT NULL,
`duration` int(11) NOT NULL,
`originalFilename` varchar(254) DEFAULT NULL,
`storedAs` varchar(254) DEFAULT NULL COMMENT 'What has this media been stored as',
`MD5` varchar(32) DEFAULT NULL,
`FileSize` bigint(20) DEFAULT NULL,
`userID` int(11) NOT NULL,
`permissionID` tinyint(1) NOT NULL DEFAULT '1',
`retired` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Is retired?',
`isEdited` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Is this the current record',
`editedMediaID` int(11) DEFAULT NULL COMMENT 'The Parent ID',
PRIMARY KEY (`mediaID`),
KEY `permissionID` (`permissionID`),
CONSTRAINT `media_ibfk_1` FOREIGN KEY (`permissionID`) REFERENCES `permission` (`permissionID`)
) ENGINE=InnoDB AUTO_INCREMENT=143 DEFAULT CHARSET=utf8;
MySQL: Can't create table 'xibo.media' (errno: 150)
but the other table are OK ..
Question information
- Language:
- English Edit question
- Status:
- Answered
- For:
- Xibo Edit question
- Assignee:
- No assignee Edit question
- Last query:
- Last reply:
This question was reopened
- by kthamma
Can you help with this problem?
Provide an answer of your own, or ask kthamma for more information if necessary.