Debugger Overview
The dbForge Studio debugger is a powerful tool that allows you to observe the runtime behavior of your database object and locate logic errors. With the debugger, you can break or suspend program execution to examine your database object, and evaluate and edit variables in your script.
As it is known MySQL database server doesn’t have its own stored procedure debugging engine. Devart company implemented a custom MySQL debug solution in the dbForge Studio for MySQL product line to debug MySQL procedures, functions, etc. For new users, it may be unclear how it works. So, we need to clarify some aspects of implementing the debugger tool.
The dbForge Studio debugger provides the Debug menu with access to debugger tools. Debugger windows and dialog display information about your database object and enable you to enter additional information. You can call Help on any window or a dialog by pressing F1.
Note
Prior to debugging, it is recommended to execute the Compile for Debugging operation, which adds debugging information to the procedure. After debugging, it is advisable to execute the Compile operation.
It is important to note that before performing these operations, the database should be backed up.
The dbForge Studio debugger provides powerful commands for controlling the execution of your code. Here is the list of the tasks you can perform to control execution using debugger commands:
- Starting (or continuing) execution of procedures, functions, triggers, and SQL scripts
- Breaking execution of procedures, functions, triggers, and SQL scripts
- Stopping execution of procedures, functions, triggers, and SQL scripts
- Stepping through the procedures, functions, triggers, and SQL scripts
- Running to a specified location
- Setting the execution point
Debug Layout
dbForge Studio has two window layouts: default and debug. The debug layout is applied when you start debugging; the rest of the time you work in the default layout. Both layouts preserve their state when starting/stopping debugging or exiting from dbForge Studio. Watches and Call Stack windows are available only in the debug layout.
Want to Find out More?
Overview
All features
Request a demo
