Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Export to SQL broken

kalvaro's profile image kalvaro posted 7 years ago in General Permalink
The new "Group objects by type" feature introduced a side effect. Export to SQL no longer works. It seems that HeidiSQL tries to export the groups themselves, rather than the individual items:

-- --------------------------------------------------------

-- Host:                         217.116.29.183

-- Server version:               5.0.32-Debian_7etch5-log - Debian etch distribution

-- Server OS:                    pc-linux-gnu

-- HeidiSQL version:             7.0.0.4164

-- Date/time:                    2012-07-20 08:41:33

-- --------------------------------------------------------


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!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' */;
-- Dumping structure for unknown, should never appear foo.Tables

DROP UNKNOWN, SHOULD NEVER APPEAR IF EXISTS `Tables`;
DROP UNKNOWN, SHOULD NEVER APPEAR IF EXISTS `Tables`;
-- Dumping structure for unknown, should never appear foo.Views

DROP UNKNOWN, SHOULD NEVER APPEAR IF EXISTS `Views`;
DROP UNKNOWN, SHOULD NEVER APPEAR IF EXISTS `Views`;
-- Dumping structure for unknown, should never appear foo.Procedures

DROP UNKNOWN, SHOULD NEVER APPEAR IF EXISTS `Procedures`;
DROP UNKNOWN, SHOULD NEVER APPEAR IF EXISTS `Procedures`;
-- Dumping structure for unknown, should never appear foo.Functions

DROP UNKNOWN, SHOULD NEVER APPEAR IF EXISTS `Functions`;
DROP UNKNOWN, SHOULD NEVER APPEAR IF EXISTS `Functions`;
-- Dumping structure for unknown, should never appear foo.Triggers

DROP UNKNOWN, SHOULD NEVER APPEAR IF EXISTS `Triggers`;
DROP UNKNOWN, SHOULD NEVER APPEAR IF EXISTS `Triggers`;
-- Dumping structure for unknown, should never appear foo.Events

DROP UNKNOWN, SHOULD NEVER APPEAR IF EXISTS `Events`;
DROP UNKNOWN, SHOULD NEVER APPEAR IF EXISTS `Events`;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
ansgar's profile image ansgar posted 7 years ago Permalink
Oh yes, nice effect, sigh...
Code modification/commit from ansgar.becker, 7 years ago, revision 4165
Issue #1031: Fix non processed table nodes in table tools dialog, due to activated grouping in tree. See http://www.heidisql.com/forum.php?t=10883
ansgar's profile image ansgar posted 7 years ago Permalink
Should be fixed in r4165, hopefully.

Please login to leave a reply, or register at first.