# Error #1071 restoring dump.

**URL:** https://forums.percona.com/t/error-1071-restoring-dump/6311
**Category:** Percona XtraDB Cluster 5.x
**Created:** [April 20, 2018, 1:27pm UTC](https://forums.percona.com/t/error-1071-restoring-dump/6311 "2018-04-20T13:27:07Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![marcio](https://avatars.discourse-cdn.com/v4/letter/m/f19dbf/32.png) [@marcio](https://forums.percona.com/u/marcio)
#### Post date: [April 20, 2018, 1:27pm UTC](https://forums.percona.com/t/error-1071-restoring-dump/6311/1 "2018-04-20T13:27:07Z")

</div>

Hello.  
I have 3 nodes XtraDB Cluster 5.7.21 and when try to restore a dump file from MariaDB I see:

#mysql -p ocs \< ocs.dump  
#ERROR 1071 (42000) at line 597: Specified key was too long; max key length is 1000 bytes

Small part of the dump file:  
DROP TABLE IF EXISTS `engine_mutex`;  
/\*!40101 SET @saved\_cs\_client = @@character\_set\_client _/;  
/_!40101 SET character\_set\_client = utf8 _/;  
CREATE TABLE `engine_mutex` (  
 `NAME` varchar(255) NOT NULL DEFAULT ‘’,  
 `PID` int(11) DEFAULT NULL,  
 `TAG` varchar(255) NOT NULL DEFAULT ‘’,  
PRIMARY KEY (`NAME`,`TAG`)  
) ENGINE=MEMORY DEFAULT CHARSET=utf8;  
/_!40101 SET character\_set\_client = @saved\_cs\_client \*/;

I changed the engine from MEMORY to InnoDB and restore it w/o errors.

The question is: if this change on the engine is the correct form to avoid the error ?  
It’s a third-party application and we can not change the code.

BR