LornaJane

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:
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!
Posted by LornaJane in tech at 21:18 | Comments (2) | Trackbacks (0)
Defined tags for this entry: ,
Related entries by tags:
Leeds Girl Geek Dinner - December 3rd
Opera's Address Bar AutoCompletion
Screen for Linux
How to Submit a Conference Talk
rsnapshot flag for usb drive

Trackbacks
Trackback specific URI for this entry

No Trackbacks

Comments
Display comments as (Linear | Threaded)

SET FOREIGN_KEY_CHECKS=0;

Seems to be the solution.

#1 Simon on 2008-07-08 07:43 (Reply)

Simon: Ah ha, I thought there was a thing to stop it from choking but I couldn’t find it – thanks for that :)

#2 LornaJane (Homepage) on 2008-07-08 07:53 (Reply)

Add Comment

You can use [geshi lang=lang_name [,ln={y|n}]][/lang] tags to embed source code snippets
Textile-formatting allowed
E-Mail addresses will not be displayed and will only be used for E-Mail notifications
 
 

Quicksearch

Comments

Midav about Surfing Without a Mouse
Fri, 21.11.2008 07:43
I love your advice. I always wanted to surf the web without having to use a mouse. I use OPERA most of the time. I just didn’t know about that spatial navigation feature. Thanks a lot


Berry about Speaking at "Beauty and the Geek"
Tue, 18.11.2008 15:11
I’m sure you’ll have no problem adjusting to that environmen t ;) Good luck on the talk.


Grace - Photostock Expert about Acer Aspire One (and cosy)
Tue, 18.11.2008 08:42
wow! i see you like it as if it’s your pet!))) that’s great i wanna say! г can call him or her Acy as i do)))


Jonas about PHP Rest Server (part 2 of 3)
Mon, 17.11.2008 22:31
Hey Lorna. Nice guide, though it did take me a bit to fig ure out which parts went in which classes. Just wanted to mention that you have a small mistake in your code: $this- >getVars[‘user_id’]) should be $this->getArgs[‘user_id’]) Since that’s what you defined in part 1 of the ser [...]


LornaJane about PHP North West Conference in Manchester - Next Week!
Mon, 17.11.2008 17:43
Stefan: Either the museum or a very long English Sunday Lunc h is on my agenda I think …


MXWest about grep: unknown directories method
Fri, 14.11.2008 17:51
Thanks! I put in a trackback here: http://www.westwideweb.co m/wp/2008/11/14/grep-unknown-directories-method/ This hel ped me out of a jam today, thanks again, MXWest


Sienna - Window about Acer Aspire One and an XD Card
Fri, 14.11.2008 10:48
hey! i have also Acer aspire and also have problems with cam era. it’s built in but this Acer Orbi Cam failed to work aft er a month…. don’t know what to do….


Stefan about PHP North West Conference in Manchester - Next Week!
Fri, 14.11.2008 08:19
That museum looks excellent, might be a good pastime for sun day :)


Stuart Herbert about Introduction to Zend_Db
Thu, 13.11.2008 10:36
The thing that gets me is this: in any non-trivial project, a model doesn’t just interact with MySQL. Models end up in caching layers, in sessions, and interacting with users thro ugh forms, query parameters, and of course APIs. Given al l that, any sort of model that is designed around tabl [...]