how to debug MySql stored procs without breaking control flow from application
Posted
by M.Taha Masood
on Stack Overflow
See other posts from Stack Overflow
or by M.Taha Masood
Published on 2010-05-30T09:24:49Z
Indexed on
2010/05/30
9:32 UTC
Read the original article
Hit count: 252
Is there a way to do the following:
I have a MySQL DB , and there are many stored procs written in it as well. I use MySQL client library in C to connect to this DB and amongst other things , call the stored procedures. Is there a way to set breakpoints in the stored procedures such that when the call is made from C program ( using mySql client library ) into the stored proc , then control flow is halted in the C program and we can step into the stored proc called to whatever level of nesting and insspecting variables etc ( like any decent C debugged provides )?
Is there ANY way to do the above ? Through some third party tool or the like if not through plain MySql .
Help is appreciated.
thanks
© Stack Overflow or respective owner
