Partitioning problem
Hello.
I get a mysql backup that I try to restore.
Some errors happen and I do not know why, and consequenlty how to solve my problem !
Here is an instruction from the infoschema file which produce an error :
CREATE TABLE `maTable` (
`NumberId` int(11) NOT NULL AUTO_INCREMENT,
`StateOfResource` BINARY(1) DEFAULT NULL,
`destinationNumber` BINARY(10) NOT NULL,
PRIMARY KEY USING HASH (`NumberId`),
UNIQUE KEY `MyDestinationNumber` USING HASH (`destinationNumber`)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1 COLLATE=latin1_bin
PARTITION BY KEY (NumberId) ;
Here is what I get :
ERROR 1503 (HY000): A UNIQUE INDEX must include all columns in the table's partitioning function
thanks
PS : I use Mysql cluster 5.1.30 under fedora. My backup come from mysql cluster 5.2.2.
Subject
Views
Written By
Posted
Partitioning problem
5181
December 02, 2008 10:21AM
2593
December 05, 2008 04:39AM
2572
December 07, 2008 08:07PM
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.