MySql cluster is unable to restore whole dump file. Error:

MaxNoOfConcurrentOperations and increase MaxNoOfAttributes

This is the command I tried:

mysql -u username -p create database databasename; use databasename; source /path/to/dump/file; 

While restore dump sql it says increases MaxNoOfConcurrentOperations in some tables and increase MaxNoOfAttributes in some tables so out of 320 tables restore only store 50 tables, rest tables are not restore with above error.

  • How's your disk space?
    – Vérace
    Jan 28, 2018 at 10:25
  • disk space is more than sufficient its 1TB and dump sql is of 114MB Jan 28, 2018 at 11:39
  • its dump sql engine=ndb and restore engine=ndb but why it says increase MaxNoOfConcurrentOperations and increase MaxNoOfAttributes it has 32GB of RAM without editing ndb config file . how to increase those two values from mysql root Jan 28, 2018 at 11:42
  • anyone could help me with this error, what could be the process to restore all tables of the database or any idea to migrate live mysql database from one to another server in linux (centos 7) Jan 29, 2018 at 8:50
  • if i change dump file engine=innodb and restore it will restore all tables but my engine is changed what to do in future to add or alter the database Jan 29, 2018 at 10:47


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Browse other questions tagged or ask your own question.