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 '18 at 10:25
  • disk space is more than sufficient its 1TB and dump sql is of 114MB – san shrestha Jan 28 '18 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 – san shrestha Jan 28 '18 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) – san shrestha Jan 29 '18 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 – san shrestha Jan 29 '18 at 10:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.