On 19 Oct 2005, at 15:58, Martijn Tonies wrote:


Second, is there any way of getting more details out of an error
message? So for example, when doing a bulk upload to the database,
rather than just getting "Cannot add or update a child row: a foreign
key constraint fails" I would like to know which particular insert
statement (out of the 1000 I have) caused the problem, or which field
in this statement broke the constraint.


Check for "innodb status" in the documentation.


Is the "innodb status" the only way. I am looking for performance too and I'm worried that parsing the whole log for the relevant error, or even using regular expressions on it might be a bit slow.

Thanks again for your help,
Ledina

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to