Bug report: export Functions/procedures simply do nothing

[expired user #9123]'s profile image [expired user #9123] posted 9 years ago in Import/Export Permalink
HeidiSQL Version 9.2.0.4947 (with Italian language package)
DB Version: 10.0.20-MariaDB

Export of functions and procedures simply writes the DB directives to generate the same CHARACTER_SET_CLIENT, CLIENT_CONNECTION and DATABASE_COLLATION, but not the definition of the function itself:
-- --------------------------------------------------------

-- Host:                         127.0.0.1

-- Versione server:              10.0.20-MariaDB-log - MariaDB Server

-- S.O. server:                  Linux

-- HeidiSQL Versione:            9.2.0.4947

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


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8mb4 */;
/*!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' */;/*!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 */;
1 attachment(s):
  • window1
ansgar's profile image ansgar posted 9 years ago Permalink
You should activate "Create tables" if you want the structure. Yes, it's wrongly named, as that applies not only to tables. I should name it "Object(s)" instead of "Table(s)".
[expired user #9123]'s profile image [expired user #9123] posted 9 years ago Permalink
Thanks, it works!

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