How to debug MySQL procedures using dbForge Studio for MySQL?

Learn how to debug MySQL stored routines (procedures, functions, triggers) using MySQL debugger in dbForge Studio for MySQL.
Learn more: http://www.devart.com/dbforge/mysql/studio/code-debugger.html

---

Closed Caption:

Welcome to dbForge Studio for MySQL
Tutorials.
In this tutorial you will learn how to:
- deploy the debug engine
- start debugging a MySQL procedure
- evaluate variables value
- and interrupt debugging by using breakpoints
You can start to debug from the "Start Page"
menu by selecting "Debug Stored
Procedures".
Alternetavly, you may go to the Debug menu
and select "Deploy Debug Engine".
If installation of debugger is successful, debug database will appear in "Database Explorer".
Now let's demonstrate the posibilities of dubugger on the example of the demo stored procedure.
Click on the SQL script, and then on
"Combined Layout".
Set a breakpoint in the procedure body by
clicking on the field near the proper line or by
choosing "Insert Breakpoint" from the popup.
We can see the invoked stored function full_actor_name.
To be able to debug the stored functions and
procedures, perform "Compile for Debugging" from the "Debug" menu.
As you see, you can also "Go to Definition"
of the function quickly.
Now let's set a break point in the function body to view its result.
Then right-click the stored procedure and select
"Compile for Debugging".
Now, let's run the debugger.
Click on the needed line and perform the "Run
To Cursor" command.
In this case debugger will execute all commands between the last executed command,
and the command in which cursor is set at the
moment.
The hint is displayed when the pointer is placed
over the invoked function, variable, etc.
Debugger allows viewing the variables value in
the Watches window.
You can perform the steps of the procedure by going to the invoked procedures and functions
with the help of the F11 key.
You can also view the value of the variable by using the "Watches" window or hint.
Now go to the "Call Stack" window. It allows you to navigate between procedures and the function being currently debugged.
Here is the result of the function.
Now return to the initial stored procedure.
To step over the invoked function, use the F10 key.
Debugging can be terminated at any moment on
users request.
You have been watching the dbForge Studio for MySQL Tutorial.
Thank you for your time.