Thank Mathew,

I tried that option, but had the syntax wrong! Now to go through the
data and see if there really are constraint errors or not.

Mark

On Wed, Mar 20, 2013 at 11:00 AM, Matthew Fonda <[address removed]> wrote:
> Hi Mark,
>
> The import will stop when it encounters errors. Often times imports
> will fail for this reason due to the order of the inserts in the dump.
> If you're confident your data does not have foreign key violations,
> you can do SET foreign_key_checks=0­ before doing the import to skip
> these errors.
>
> Regards,
> --Matthew
>
> On Wed, Mar 20, 2013 at 10:38 AM, Mark Steudel <[address removed]> wrote:
>> I'm trying to recreate a database from a sql dump and I'm getting some
>> foreign constraint failed. When the import routine runs into foreign
>> constraint error does it continue on to try and run the rest of the
>> query or does it stop midway? These insert queries are multiple
>> records, e.g.
>>
>> Insert (val1, val2, val3), (val2-1, val2-2, val2-3 ), (etc)
>>
>> TIA
>>
>> --
>> --------------------­--------------------­-
>> Mark Steudel
>> P:[masked]
>> F:[masked]
>> [address removed]
>>
>> . : Adoption Updates : .
>> https://www.steude...­
>>
>> . : Work : .
>> https://www.mindfu...­
>>
>> . : LinkedIn : .
>> https://www.linked...­
>>
>>
>>
>> --
>> Please Note: If you hit "REPLY", your message will be sent to everyone on this mailing list ([address removed])
>> https://www.meetup...­
>> This message was sent by Mark Steudel ([address removed]) from The Seattle PHP Meetup Group.
>> To learn more about Mark Steudel, visit his/her member profile: https://www.meetup...­
>> Set my mailing list to email me
>>
>> As they are sent
>> https://www.meetup...­
>>
>> In one daily email
>> https://www.meetup...­
>>
>> Don't send me mailing list messages
>> https://www.meetup...­
>> Meetup, POB 4668 #37895 NY NY USA 10163 | [address removed]
>>
>
>
>
> --
> Please Note: If you hit "REPLY", your message will be sent to everyone on this mailing list ([address removed])
> https://www.meetup...­
> This message was sent by Matthew Fonda ([address removed]) from The Seattle PHP Meetup Group.
> To learn more about Matthew Fonda, visit his/her member profile: https://www.meetup...­
> Set my mailing list to email me
>
> As they are sent
> https://www.meetup...­
>
> In one daily email
> https://www.meetup...­
>
> Don't send me mailing list messages
> https://www.meetup...­
> Meetup, POB 4668 #37895 NY NY USA 10163 | [address removed]
>



--
--------------------­--------------------­-
Mark Steudel
P:[masked]
F:[masked]
[address removed]

. : Adoption Updates : .
https://www.steude...­

. : Work : .
https://www.mindfu...­

. : LinkedIn : .
https://www.linked...­