how to debug MySql stored procs without breaking control flow from application
- by M.Taha Masood
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