[MDEV-5571] compatibility to old mysqldump between versions tokudb-5.X 10 10.X Created: 2014-01-26  Updated: 2022-09-08

Status: Open
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.0.7
Fix Version/s: None

Type: Bug Priority: Minor
Reporter: Joni-Pekka Kurronen Assignee: Unassigned
Resolution: Unresolved Votes: 1
Labels: None
Environment:

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`



 Comments   
Comment by Sergei Golubchik [ 2014-01-28 ]

There isn't much we can do. mysqldump output is perfectly compatible between mariadb-5.5 and mariadb-10.0. It is not compatible with tokutek-patched releases.

As a workaround, you could edit the dump, replacing "ROW_FORMAT=TOKUDB" with "COMPRESSION=TOKUDB". Or you can simply start MariaDB on the same datadir and generate the dump in MariaDB. Then it'll use correct MariaDB-compatible syntax.

Generated at Thu Feb 08 07:05:24 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.