[LRUG] mysqldump not working

[Riccardo Tacconi]

Thanks Kenneth,

Now as least I get an error:

CREATE TABLE `dept` (
  `deptID` smallint(5) unsigned NOT NULL auto_increment,
  `honcho_userID` mediumint(8) unsigned NOT NULL default '11' COMMENT
'honcho',
  `parent_deptID` smallint(5) unsigned default NULL COMMENT 'deptID',
  `ordinal` tinyint(3) unsigned NOT NULL default '0',
  `deptName` varchar(63) NOT NULL,
  `code` varchar(10) default NULL,
  `description` text,
  `contact_us` text,
  `display` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`deptID`),
  UNIQUE KEY `deptName` (`deptName`),
  KEY `userID` (`honcho_userID`),
  KEY `parentID` (`parent_deptID`),
  CONSTRAINT `dept_ibfk_28` FOREIGN KEY (`honcho_userID`) REFERENCES `user`
(`userID`) ON DELETE SET NULL ON UPDATE SET NULL,
  CONSTRAINT `dept_ibfk_29` FOREIGN KEY (`parent_deptID`) REFERENCES `dept`
(`deptID`) ON DELETE SET NULL ON UPDATE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8
--------------

ERROR 1005 (HY000) at line 447: Can't create table
'./intranet_dump/dept.frm' (errno: 150)

I think the problem are the the foreign keys. I had the same error with
phpMyAdmin.


On Wed, Feb 3, 2010 at 3:42 PM, Kenneth Lee <kenfodder at gmail.com> wrote:

>  When you restore you don't use mysqldump just mysql.
>
> Try this...
>
> -bash-3.00$ *mysql* -uriccardot -p intranet_dump < intranet2.sql
>
> NOT...
>
>
> -bash-3.00$ *mysqldump* -uriccardot -p intranet_dump < intranet2.sql
>
> Ken
>
> _______________________________________________
> Chat mailing list
> Chat at lists.lrug.org
> http://lists.lrug.org/listinfo.cgi/chat-lrug.org
>
>


-- 
Riccardo Tacconi
Web developer at Wolseley UK
VIRTUELOGIC LIMITED (Director)

http://www.linkedin.com/in/riccardotacconi
http://riccardotacconi.blogspot.com/
http://twitter.com/rtacconi
Linux user: #400461
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lrug.org/pipermail/chat-lrug.org/attachments/20100203/39354063/attachment-0003.html>