1

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.

Improve this question
8
  • How's your disk space?
    – Vérace
    Commented Jan 28, 2018 at 10:25
  • disk space is more than sufficient its 1TB and dump sql is of 114MB
    – san shrestha
    Commented 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
    – san shrestha
    Commented 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)
    – san shrestha
    Commented 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
    – san shrestha
    Commented Jan 29, 2018 at 10:47

0

Reset to default

Your Answer

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

Browse other questions tagged or ask your own question.