Problem with Debugging

[ChrisBell]

I don't know whether it's me - but I am having a problem with the debugger

I have loaded in a script that was actually generated by the backup facility from the MySQL GUI Administrator - because I'd been having problems with the creation of some of the tables when trying to do a restore using it....

I set a number of breakpoints in the script - which showed up OK having a red dot in the left hand column with the line highlighted in red

When I clicked the Start button - or Ctrl-F5 to run it - it completely ignored my breakpoints and ran through to the end of the script

I am using 2.10.78 under Windows XP - SP2

[Elias]

Did you try to Step In through the script? Can you give us the sample of the script to reproduce the problem?

[ChrisBell]

Step in worked OK - I just couldn't get execution to halt at the breakpoints I set

Here is part of the script I was using....

-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version 4.0.12-max-nt


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;


--
-- Create schema mysiteforlessdb
--

CREATE DATABASE IF NOT EXISTS mysiteforlessdb;
USE mysiteforlessdb;

--
-- Definition of table `mos_banner`
--

DROP TABLE IF EXISTS `mos_banner`;
CREATE TABLE `mos_banner` (
`bid` int(11) NOT NULL auto_increment,
`cid` int(11) NOT NULL default '0',
`type` varchar(10) NOT NULL default 'banner',
`name` varchar(50) NOT NULL default '',
`imptotal` int(11) NOT NULL default '0',
`impmade` int(11) NOT NULL default '0',
`clicks` int(11) NOT NULL default '0',
`imageurl` varchar(100) NOT NULL default '',
`clickurl` varchar(200) NOT NULL default '',
`date` datetime default NULL,
`showBanner` tinyint(1) NOT NULL default '0',
`checked_out` tinyint(1) NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`editor` varchar(50) default NULL,
`custombannercode` text,
PRIMARY KEY (`bid`),
KEY `viewbanner` (`showBanner`)
) TYPE=MyISAM;

--
-- Dumping data for table `mos_banner`
--

/*!40000 ALTER TABLE `mos_banner` DISABLE KEYS */;
/*!40000 ALTER TABLE `mos_banner` ENABLE KEYS */;


--
-- Definition of table `mos_bannerclient`
--

DROP TABLE IF EXISTS `mos_bannerclient`;
CREATE TABLE `mos_bannerclient` (
`cid` int(11) NOT NULL auto_increment,
`name` varchar(60) NOT NULL default '',
`contact` varchar(60) NOT NULL default '',
`email` varchar(60) NOT NULL default '',
`extrainfo` text NOT NULL,
`checked_out` tinyint(1) NOT NULL default '0',
`checked_out_time` time default NULL,
`editor` varchar(50) default NULL,
PRIMARY KEY (`cid`)
) TYPE=MyISAM;

--
-- Dumping data for table `mos_bannerclient`
--

/*!40000 ALTER TABLE `mos_bannerclient` DISABLE KEYS */;
/*!40000 ALTER TABLE `mos_bannerclient` ENABLE KEYS */;


--
-- Definition of table `mos_bannerfinish`
--

DROP TABLE IF EXISTS `mos_bannerfinish`;
CREATE TABLE `mos_bannerfinish` (
`bid` int(11) NOT NULL auto_increment,
`cid` int(11) NOT NULL default '0',
`type` varchar(10) NOT NULL default '',
`name` varchar(50) NOT NULL default '',
`impressions` int(11) NOT NULL default '0',
`clicks` int(11) NOT NULL default '0',
`imageurl` varchar(50) NOT NULL default '',
`datestart` datetime default NULL,
`dateend` datetime default NULL,
PRIMARY KEY (`bid`)
) TYPE=MyISAM;

--
-- Dumping data for table `mos_bannerfinish`
--

/*!40000 ALTER TABLE `mos_bannerfinish` DISABLE KEYS */;
/*!40000 ALTER TABLE `mos_bannerfinish` ENABLE KEYS */;


--
-- Definition of table `mos_categories`
--

DROP TABLE IF EXISTS `mos_categories`;
CREATE TABLE `mos_categories` (
`id` int(11) NOT NULL auto_increment,
`parent_id` int(11) NOT NULL default '0',
`title` varchar(50) NOT NULL default '',
`name` varchar(255) NOT NULL default '',
`image` varchar(100) NOT NULL default '',
`section` varchar(50) NOT NULL default '',
`image_position` varchar(10) NOT NULL default '',
`description` text NOT NULL,
`published` tinyint(1) NOT NULL default '0',
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`editor` varchar(50) default NULL,
`ordering` int(11) NOT NULL default '0',
`access` tinyint(3) unsigned NOT NULL default '0',
`count` int(11) NOT NULL default '0',
`params` text NOT NULL,
PRIMARY KEY (`id`),
KEY `cat_idx` (`section`,`published`,`access`),
KEY `idx_section` (`section`),
KEY `idx_access` (`access`),
KEY `idx_checkout` (`checked_out`)
) TYPE=MyISAM;

--
-- Dumping data for table `mos_categories`
--

I was testing out the breakpoint facility and had set them on each of the DROP DATABASE statements

[Elias]

Unfortunately we cannot reproduce the problem on MySql 4.0.12 using MyDeveloper 2.10.78. Does debugger run to the end of the script? May be it hangs on some query execution and cannot run to the breakpoint?