Skip navigation links

MySQL Forums :: Cluster :: Using mysqldump to backup databases using ndbcluster


Advanced Search

Using mysqldump to backup databases using ndbcluster
Posted by: piyush nagar ()
Date: December 24, 2012 03:06AM

Hi ,

I have very urgent questions related to backup/restores of databases in a node of ndbcluster environment.

I used mysqldump to backup all the databases. it got successful. Now when i try to restores those db dumps, i see the error in restoring 'mysql' system database.

here are the results:

[root@IfxLinux mysql-cluster]# mysql < /tmp/my.sql
ERROR 1036 (HY000) at line 386: Table 'ndb_apply_status' is read only

error says 'ndb_apply_status' table is read only and restore halts.

even dropping 'mysql' database shows error:
system command = /usr/bin/mysql -u backup --socket=/var/lib/mysql-cluster/mysql.sock -e 'FLUSH PRIVILEGES;drop database `mysql`;' out err = ERROR 1051 (42S02) at line 1: Unknown table 'ndb_apply_status'.


Please help and advise how to resolve this. We are able to restore all other databases apart from 'mysql' database from a dump.

#Note: we don't want to use start backup and ndb_restore programs.

Help appreciated.

Options: ReplyQuote


Subject Views Written By Posted
Using mysqldump to backup databases using ndbcluster 866 piyush nagar 12/24/2012 03:06AM


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.