Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-5571

compatibility to old mysqldump between versions tokudb-5.X 10 10.X

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 10.0.7
    • None
    • None
    • None
    • Ubuntu 12.4 LTS

    Description

      root@mpi2:/var/backup/today# /opt/maria*/bin/mysql -u root -paptk#7315 bacula < bacula.sql
      ERROR 1064 (42000) at line 25: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TOKUDB_ZLIB' at line 8
      root@mpi2:/var/backup/today# 

      problem:

      ROW_FORMAT=TOKUDB_ZLIB;

      bacula.sql:

      -- MySQL dump 10.14  Distrib 5.5.30-tokudb-7.1.0-MariaDB, for Linux (x86_64)
      --
      -- Host: localhost    Database: bacula
      -- ------------------------------------------------------
      -- Server version	5.5.30-tokudb-7.1.0-MariaDB-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 */;
       
      --
      -- Table structure for table `BaseFiles`
      --
       
      DROP TABLE IF EXISTS `BaseFiles`;
      /*!40101 SET @saved_cs_client     = @@character_set_client */;
      /*!40101 SET character_set_client = utf8 */;
      CREATE TABLE `BaseFiles` (
        `BaseId` int(10) unsigned NOT NULL AUTO_INCREMENT,
        `BaseJobId` int(10) unsigned NOT NULL,
        `JobId` int(10) unsigned NOT NULL,
        `FileId` bigint(20) unsigned NOT NULL,
        `FileIndex` int(10) unsigned DEFAULT NULL,
        PRIMARY KEY (`BaseId`)
      ) ENGINE=TokuDB DEFAULT CHARSET=latin1 ROW_FORMAT=TOKUDB_ZLIB;
      /*!40101 SET character_set_client = @saved_cs_client */;
       
      --
      -- Dumping data for table `BaseFiles`
      --
       
      LOCK TABLES `BaseFiles` WRITE;
      /*!40000 ALTER TABLE `BaseFiles` DISABLE KEYS */;
      /*!40000 ALTER TABLE `BaseFiles` ENABLE KEYS */;
      UNLOCK TABLES;
       
      --
      -- Table structure for table `Client`

      Attachments

        Activity

          People

            Unassigned Unassigned
            boy007 Joni-Pekka Kurronen
            Votes:
            1 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.