Failed to create TABLESPACE
Hi, I am running cluster with 2 data nodes, 1 SQL and 1 Management node. My cluster is running fine. I thought of taking database dump using "mysqldump" utility and I took it successfully. Now when I am trying to restore dump (which I took it from mysqldump), I am getting error "Failed to create TABLESPACE".
Below is my mgm-config
[ndbd default]
# Options affecting ndbd processes on all data nodes:
NoOfReplicas=2 # Number of replicas
DataDir=D:\\mysql-cluster\\cluster-data # Directory for each data node's data files
DataMemory=8M # Memory allocated to data storage
IndexMemory=8M # Memory allocated to index storage
# For DataMemory and IndexMemory, we have used the
# default values. Since the "world" database takes up
# only about 500KB, this should be more than enough for
# this example Cluster setup.
[ndb_mgmd]
# Management process options:
HostName=127.0.0.1 # Hostname or IP address of management node
DataDir=D:\\mysql-cluster\\cluster-log # Directory for management node log files
NodeID=1
[ndbd]
# Options for data node "A":
# (one [ndbd] section per data node)
HostName=127.0.0.1 # Hostname or IP address
NodeID=2
[ndbd]
# Options for data node "B":
HostName=127.0.0.1 # Hostname or IP address
NodeID=3
[mysqld]
# SQL node options:
HostName=127.0.0.1 # Hostname or IP address
NodeID=4
D:\mysql-cluster\mysql\bin>mysql -uroot clusterdb < D:\clusterdb.sql
ERROR 1528 (HY000) at line 22: Failed to create TABLESPACE
My cluststerdb.sql file(which I took using mysqldump) output is below.
-- MySQL dump 10.13 Distrib 5.6.31-ndb-7.4.12, for Win64 (x86_64)
--
-- Host: localhost Database: clusterdb
-- ------------------------------------------------------
-- Server version 5.6.31-ndb-7.4.12-cluster-gpl-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 */;
--
-- Tablespace: ts_1
--
CREATE TABLESPACE ts_1
ADD DATAFILE 'data_2.dat'
USE LOGFILE GROUP lg_1
EXTENT_SIZE 1048576
INITIAL_SIZE 50331648
ENGINE=ndbcluster;
ALTER TABLESPACE ts_1
ADD DATAFILE 'data_1.dat'
INITIAL_SIZE 33554432
ENGINE=ndbcluster;
--
-- Table structure for table `dt_1`
--
I have also given full permission to data directory.
Not sure what need to be changed in configuration or am I missing any parameter in restore command.
Thanks in advance
Subject
Views
Written By
Posted
Failed to create TABLESPACE
3893
October 17, 2016 10:15AM
1066
October 17, 2016 12:15PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.