[LRUG] mysqldump not working

Kenneth Lee kenfodder at gmail.com
Wed Feb 3 09:04:53 PST 2010


Glad you found the problem.

Ken

Riccardo Tacconi wrote:
> This line was causing the error: `honcho_userID` mediumint(8) unsigned 
> NOT NULL default '11' COMMENT 'honcho'
>
> Thanks for your help.
>
> On Wed, Feb 3, 2010 at 4:24 PM, Riccardo Tacconi <rtacconi at gmail.com 
> <mailto:rtacconi at gmail.com>> wrote:
>
>     Using perror 150 I understood that. I have found this post:
>     http://bugs.mysql.com/bug.php?id=7831 but I do not see any
>     difference in the filed type.
>
>
>     On Wed, Feb 3, 2010 at 4:02 PM, David Salgado
>     <david at digitalronin.com <mailto:david at digitalronin.com>> wrote:
>
>         > ERROR 1005 (HY000) at line 447: Can't create table
>         > './intranet_dump/dept.frm' (errno: 150)
>
>         Possible solution here;
>
>         http://forums.mysql.com/read.php?22,19755,269293#msg-269293
>
>         If I'm reading it correctly, it implies there might be a type
>         mismatch
>         between the key field and the field it's referencing - i.e.
>         one is a
>         signed integer and the other is unsigned (or vice versa).
>
>         Hope this helps.
>
>         David
>         _______________________________________________
>         Chat mailing list
>         Chat at lists.lrug.org <mailto: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
>
>
>
>
> -- 
> 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
> ------------------------------------------------------------------------
>
> _______________________________________________
> Chat mailing list
> Chat at lists.lrug.org
> http://lists.lrug.org/listinfo.cgi/chat-lrug.org
>    
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lrug.org/pipermail/chat-lrug.org/attachments/20100203/b6b32a1d/attachment-0003.html>


More information about the Chat mailing list