You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
-- Server version 10.4.8-MariaDB-1:10.4.8+maria~bionic-log mariadb.org binary distribution
/*!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' /;
/!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Dumping functions
DROP FUNCTION IF EXISTS TEST;
DELIMITER §§§
CREATE FUNCTION TEST() RETURNS int(11)
DETERMINISTIC
RETURN 8081; §§§
DELIMITER ;`
A quick workaround until Oracle solves the problem seems to make in line 1372 in the class MySqlBackup.cs in the method "Import_AppendLineAndExecute" no AppendLine but only an Append.
Retores of procedures do not seem to work under Linux due to the following bug in the Mysql connector:
https://bugs.mysql.com/bug.php?id=98037
If you try to restore this script under Linux a syntax exception occurs:
`-- MySqlBackup.NET 2.3.1
-- Dump Time: 2019-12-18 14:04:41
-- Server version 10.4.8-MariaDB-1:10.4.8+maria~bionic-log mariadb.org binary distribution
/*!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' /;
/!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Dumping functions
DROP FUNCTION IF EXISTS
TEST
;DELIMITER §§§
CREATE FUNCTION
TEST
() RETURNS int(11)DETERMINISTIC
RETURN 8081; §§§
DELIMITER ;`
A quick workaround until Oracle solves the problem seems to make in line 1372 in the class MySqlBackup.cs in the method "Import_AppendLineAndExecute" no AppendLine but only an Append.
void Import_AppendLineAndExecute(string line) { _sbImport.Append(line); //if (!line.EndsWith(_delimiter)) // return;
The Mysql connector seems to have problems with the last line break (\n) under Linux.
The text was updated successfully, but these errors were encountered: