Hi folks. Just getting back into the swing of things and I got a new domain for my website and tried to use Big Dump for the database and it failed. So i tired to do it manually via phpMyAdmin and it is not wanting to create several tables. Funny part is, it is the same server, but different domain name. I do not have any clue why it dont want to create them tables now.
I went back to my old domain and created the same exact database and all info was imported successfully. Kinda odd huh?
Heres one example. Its probably so dam simple that it is not even gonna be funny when I figure it out
SQL query:
CREATE TABLE `phpvms_fieldvalues` (
`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`fieldid` int( 11 ) NOT NULL ,
`pilotid` int( 11 ) NOT NULL ,
`value` text NOT NULL ,
PRIMARY KEY ( `id` ) ,
KEY `phpvms_fieldvalues_ibfk_1` ( `fieldid` ) ,
KEY `phpvms_fieldvalues_ibfk_2` ( `pilotid` ) ,
CONSTRAINT `phpvms_fieldvalues_ibfk_1` FOREIGN KEY ( `fieldid` ) REFERENCES `phpvms_customfields` ( `fieldid` ) ON DELETE CASCADE ,
CONSTRAINT `phpvms_fieldvalues_ibfk_2` FOREIGN KEY ( `pilotid` ) REFERENCES `phpvms_pilots` ( `pilotid` ) ON DELETE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = latin1;
MySQL said: Documentation
#1005 - Can't create table './thundxxxx_xxxxxx/phpvms_fieldvalues.frm' (errno: 150) (<a href="server_engines.php?engine=InnoDB&page=Status&token=5338c65169ccb620d9f7f9f2bbae3bf8">Details...</a>)
Obviously I put the X's on here on purpose