Mysql Error
Monday, July 7. 2008
I was running an import script today taken from a mysqldump from another user, when I saw an error that looked like this:
This is caused by a mysqldump or export process exporting tables in alphabetical order and not in the order in which they rely on one another. My tables had foreign keys which fail on import if the other table doesn't exist when you create the table with the key. In this case I was only importing six or eight tables so I simply opened the script in a text editor and re-ordered the import blocks. On a bigger scale a more technical solution might be required!
ERROR 1005 (HY000) at line 123: Cant create table(errno: 150)
This is caused by a mysqldump or export process exporting tables in alphabetical order and not in the order in which they rely on one another. My tables had foreign keys which fail on import if the other table doesn't exist when you create the table with the key. In this case I was only importing six or eight tables so I simply opened the script in a text editor and re-ordered the import blocks. On a bigger scale a more technical solution might be required!
(Page 1 of 1, totaling 1 entries)
Comments
Mon, 05.01.2009 13:06
Doh! Interesting that you play piano, didn’t know that pi ece!
Mon, 05.01.2009 10:46
Daniel: I completely agree. I do like and use Zend Framewor k, but I already have books about it. When I buy a book on a subject, I don’t really want lots of ZF content. I can on ly assume that because its seen as a “buzz word”, people fee l the need to include it in any books current being wr [...]
Mon, 05.01.2009 10:41
Ubuntu User, Prasad, Joe – I’m pleased this was helpful, tha nks so much for dropping by and letting me know it worked ou t for you :)
Sun, 04.01.2009 23:25
Thanks for the tagging :) I responded (first time ever): htt p://www.urbanwide.com/2009/01/05/7-things/
Sun, 04.01.2009 06:42
You are my freakin’ hero! Thank you soooo much! mainMem.useN amedFile=FALSE fixed all my problems, my wife came back, I w on the lottery….. :) Thanks! Joe
Fri, 02.01.2009 23:33
I agree with your issues about some of the book turning into a mini ZF tutorial book. I feel that lately a lot of spa ce has been wasted on PHP books re-explaining MVC concepts, THEN introducing ZF (or another framework). Chalk it up to p ublishers not wanting to assume everyone reading the b [...]
Fri, 02.01.2009 00:44
All the best for Peru, and the rest of 2009!
Thu, 01.01.2009 23:33
Berry__: For normal people that is probably true but I add all sorts of clues which are different per-server, and still find myself regularly confused about which machine I’m logg ed in to …
Tue, 30.12.2008 15:23
Although I kinda like the colors for tabs, I think it’s over kill to have different colors on different servers. To be ho unest, I think the name of the machine you’re working on (on the left) is clear enough when working with it. The only thing I tend to dislike in screen, is that it’s rathe [...]