[LRUG] mysqldump not working

Riccardo Tacconi rtacconi at gmail.com
Wed Feb 3 09:01:18 PST 2010


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> 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>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
>



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


More information about the Chat mailing list