PDA

View Full Version : MyPHPAdmin database upload error


rhpapts
11-01-2006, 04:08 PM
I've created my dbase ands user.
I've used mysqldump to create a copy of my dbase from my local dev server.
I'm using MyPHPAdmin to upload the database.

It barfs. On the first table. The error data is below:

BEGIN OUTPUT*****************************************
Error

SQL query:

CREATE TABLE `admindocuments` (
`DocumentsId` int( 10 ) NOT NULL AUTO_INCREMENT ,
`CityId` int( 10 ) default NULL ,
`Type` varchar( 50 ) default NULL ,
`FileName` varchar( 255 ) default NULL ,
`Memo` longtext,
`Description` longtext,
`Version` varchar( 255 ) default NULL ,
`DateCreated` datetime default NULL ,
`DateUpdated` datetime default NULL ,
`ShowBoolean` tinyint( 1 ) NOT NULL ,
PRIMARY KEY ( `DocumentsId` ) ,
KEY `document_id` ( `DocumentsId` ) ,
KEY `resources_city_child_id` ( `CityId` ) ,
KEY `tbl_lookup_citytbl_documents` ( `CityId` ) ,
CONSTRAINT `FK_admindocuments` FOREIGN KEY ( `CityId` ) REFERENCES `mastercities` ( `CityId` ) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = latin1;

MySQL said: Documentation
#1005 - Can't create table './rhpapts_rhp/admindocuments.frm' (errno: 150)
END OUTPUT*******************************************

Any clues, folks?