[LRUG] mysqldump not working

Riccardo Tacconi rtacconi at gmail.com
Wed Feb 3 08:24:59 PST 2010


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>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
> 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/86335923/attachment-0003.html>


More information about the Chat mailing list