Details
-
Type:
Bug
-
Status: Open
-
Priority:
Minor
-
Resolution: Unresolved
-
Affects Version/s: 10.0.7
-
Fix Version/s: 10.0
-
Component/s: None
-
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`
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
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.