MySQL stored procedure debugging

Question

Hello,

do you have any tips for some GUI applications (free) that are capable of debugging MySQL stored procedures?

I tried devArt dbForge MySQL Studio which worked just fine, but it's not free.

Thanks for any tips.

Answer 1

Unfortunately, there don't appear to be any free alternatives.

There is Illatis Stepin - an Eclipse-based IDE for debugging stored procedures. Price is $40 per licence. There is also MySQL Debugger, $50 per head. However, MyDebugger are offering licences if you have a blog - you get a license in return for blogging about the product.

Is the debugger for use in an open source project? If so you might try contacting the publishers to see if they will grant you a license, perhaps in return for a mention on your project page.

If it's for commercial development, you might try getting approval for the $40-50 license fee. The debugger could potentially save you hours of time, and so will almost certainly pay for itself within the first year, if not quicker.

If neither of those are options, you might setup a small blog and try to get a free MyDebugger licence!

Answer 2

SQLYog Community Edition might be able to do this sort of thing http://www.webyog.com/en/downloads.php

Answer 3

I would recommend trying phpmyadmin.

Recent versions have a "delimiter" field separate from the SQL window that can be used to assist in generating stored procedures.

I am not certain that phpmyadmin has features specifically designed to help you sort out what is wrong with your stored procedure, but it does have a helpful "two window" mode for debugging sql generally (look for the "show this query in a new window" and then once youhave the new window be sure to click "do not overwrite this sql" checkbox. That will let you edit the query in one window and see the results in another.

HTH,