Skip to content
This repository has been archived by the owner on Aug 10, 2022. It is now read-only.

Error with MySql-Configs #10

Open
Waschnick opened this issue Nov 30, 2015 · 0 comments
Open

Error with MySql-Configs #10

Waschnick opened this issue Nov 30, 2015 · 0 comments

Comments

@Waschnick
Copy link

Really like your tool, saved me a lot of time.

Lines like this seem to not work:

SET @MYSQLDUMP_TEMP_LOG_BIN = @@SESSION.SQL_LOG_BIN;
SET @@SESSION.SQL_LOG_BIN= 0;


SET @@GLOBAL.GTID_PURGED='0f1f94eb-5891-11e5-8f0e-005056992d4d:1-730085,
500ab157-5894-11e5-8f23-00505685788b:1-12738';


SET @@SESSION.SQL_LOG_BIN = @MYSQLDUMP_TEMP_LOG_BIN;

This is the Start of my file:

-- MySQL dump 10.13  Distrib 5.6.27, for Linux (x86_64)
--
-- Host: localhost    Database: xxx
-- ------------------------------------------------------
-- Server version   5.6.27-log

/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!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 */;
SET @MYSQLDUMP_TEMP_LOG_BIN = @@SESSION.SQL_LOG_BIN;
SET @@SESSION.SQL_LOG_BIN= 0;

--
-- GTID state at the beginning of the backup 
--

SET @@GLOBAL.GTID_PURGED='0f1f94eb-5891-11e5-8f0e-005056992d4d:1-730085,
500ab157-5894-11e5-8f23-00505685788b:1-12738';

And this the error:

Exception in thread "main" com.granveaud.mysql2h2converter.parser.TokenMgrError: Lexical error at line 17, column 5.  Encountered: "@" (64), after : ""
        at com.granveaud.mysql2h2converter.parser.SQLParserTokenManager.getNextToken(SQLParserTokenManager.java:1806)
        at com.granveaud.mysql2h2converter.parser.SQLParser.jj_ntk(SQLParser.java:3058)
        at com.granveaud.mysql2h2converter.parser.SQLParser.DbObjectName(SQLParser.java:1922)
        at com.granveaud.mysql2h2converter.parser.SQLParser.Assignment(SQLParser.java:1969)
        at com.granveaud.mysql2h2converter.parser.SQLParser.SetVariableStatement(SQLParser.java:137)
        at com.granveaud.mysql2h2converter.parser.SQLParser.Statement(SQLParser.java:100)
        at com.granveaud.mysql2h2converter.parser.SQLParser.ScriptStatement(SQLParser.java:76)
        at com.granveaud.mysql2h2converter.parser.SQLParserManager$ScriptIterator.parseNextStatement(SQLParserManager.java:23)
        at com.granveaud.mysql2h2converter.parser.SQLParserManager$ScriptIterator.next(SQLParserManager.java:37)
        at com.granveaud.mysql2h2converter.parser.SQLParserManager$ScriptIterator.next(SQLParserManager.java:12)
        at com.granveaud.mysql2h2converter.converter.H2Converter$ConverterIterator.loadNextStatements(H2Converter.java:28)
        at com.granveaud.mysql2h2converter.converter.H2Converter$ConverterIterator.<init>(H2Converter.java:23)
        at com.granveaud.mysql2h2converter.converter.H2Converter.convertScript(H2Converter.java:221)
        at com.granveaud.mysql2h2converter.converter.Main.main(Main.java:28)
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant