How to debug MySQL procedures using dbForge Studio for MySQL?

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.

Video Length: 02:54
Uploaded By: Devart
Published: 4/24/2014
View Count: 16,438

Related Software Products
dbForge Studio for MySQL
dbForge Studio for MySQL

Published By:
Devart

Description:
dbForge Studio for MySQL: A Full MySQL and MariaDB IDE With a Debugger, Compare Tools and Reports dbForge Studio for MySQL is Devart's Windows IDE for MySQL and MariaDB: a SQL editor with smart completion, a stored procedure debugger, a visual query builder and database designer, backup and restore, and, in the Professional edition, schema and data compare with sync scripts. Professional costs $179.95 a year (Standard $99.95, Enterprise $229.95...


Related Videos
How to create MySQL foreign key between two tables?
How to create MySQL foreign key between two tables?

Video Length: 01:34
Uploaded By: Devart (7/1/2013)
View Count: 96,329

MySQL and MariaDB client for Windows with GUI environment
MySQL and MariaDB client for Windows with GUI environment

Video Length: 04:17
Uploaded By: Devart (8/11/2014)
View Count: 25,437

How to create a simple connection using dbForge Studio for MySQL?
How to create a simple connection using dbForge Studio for MySQL?

Video Length: 02:54
Uploaded By: Devart (4/24/2014)
View Count: 20,026

How to Optimize MySQL Queries with Query Profiler by Devart?
How to Optimize MySQL Queries with Query Profiler by Devart?

Video Length: 02:58
Uploaded By: Devart (4/24/2014)
View Count: 18,197

How To: Export and Import Data with dbForge Studio for MySQL
How To: Export and Import Data with dbForge Studio for MySQL

Video Length: 02:58
Uploaded By: Devart (2/13/2015)
View Count: 15,187

Ultimate MySQL and MariaDB GUI Tool - #dbForge Studio for MySQL
Ultimate MySQL and MariaDB GUI Tool - #dbForge Studio for MySQL

Video Length: 06:28
Uploaded By: Devart (4/4/2018)
View Count: 13,669

What is the Best GUI tool for MySQL? Comprehensive overview of dbForge Studio for MySQL
What is the Best GUI tool for MySQL? Comprehensive overview of dbForge Studio for MySQL

Video Length: 05:51
Uploaded By: 0xSECRETenv (9/29/2022)
View Count: 6,992

How to connect to MySQL Database using dbForge Studio for MySQL [Easiest way]
How to connect to MySQL Database using dbForge Studio for MySQL [Easiest way]

Video Length: 04:58
Uploaded By: Devart (9/14/2021)
View Count: 6,606

The most offbeat promo video for software!
The most offbeat promo video for software!

Video Length: 01:13
Uploaded By: Devart (5/26/2011)
View Count: 4,729

The Ultimate Guide to Version Control in dbForge Studio for MySQL
The Ultimate Guide to Version Control in dbForge Studio for MySQL

Video Length: 02:43
Uploaded By: Devart (11/3/2023)
View Count: 790

Copyright © 2026, Ivertech. All rights reserved.