List:Cluster« Previous MessageNext Message »
From:franco riggi Date:April 10 2012 8:14am
Subject:Re: REG:ndb_restore failed in mysql cluster.
View as plain text  
Hi Periyannan,

The reason of that is because the previosly run with the -m option failed
so you got a partial recover of the database schema and now ndb_restore is
claiming about missing tables.
What I suggest you to do is:
1) Drop manually the database you are trying to recover.
2) run ndb_restore using the -m option.

I do not remember if the  -m is able to do a "create database <dbname>" .
If not just do again the steps plus one more
1.a) Create your database with no tables.


Regards,
Francesco


2012/4/6 periyannan natarajan <periyannan.natarajan@stripped>

> Dear Friends,
>
> I try to restore my backup in one of My API machine,but it is showing below
> error:
>
> root@brdvox07:/var/lib/mysql-cluster/BACKUP/BACKUP-2# ndb_restore -c
> 192.168.168.43:1186 -b 2 -r -n 2 /var/lib/mysql-cluster/BACKUP/BACKUP-2/
> Backup Id = 2
> Nodeid = 2
> backup path = /var/lib/mysql-cluster/BACKUP/BACKUP-2/
> Opening file '/var/lib/mysql-cluster/BACKUP/BACKUP-2/BACKUP-2.2.ctl'
> Backup version in files: ndb-6.3.11 ndb version: mysql-5.1.51 ndb-7.1.9
> Stop GCP of Backup: 13568
> Connected to ndb!!
> *Unable to find table: `peri`
> Restore: Failed to restore table: `peri/def/peri` ... Exiting
>
> NDBT_ProgramExit: 1 - Failed
> *
> root@brdvox07:/var/lib/mysql-cluster/BACKUP/BACKUP-2#
>
> I searched to rectify in all ways but it is not restoring,Please give idea
> to rectify.
>
> Thanks and Regards,
> Periyannan Natarajan.
>
>
> --
> View this message in context:
>
> http://mysql-cluster.1050023.n4.nabble.com/REG-ndb-restore-failed-in-mysql-cluster-tp4531104p4536875.html
> Sent from the MySQL - Cluster mailing list archive at Nabble.com.
>
> --
> MySQL Cluster Mailing List
> For list archives: http://lists.mysql.com/cluster
> To unsubscribe:    http://lists.mysql.com/cluster
>
>

Thread
REG:ndb_restore failed in mysql cluster.periyannan natarajan4 Apr
  • Re: REG:ndb_restore failed in mysql cluster.periyannan natarajan5 Apr
    • Re: REG:ndb_restore failed in mysql cluster.franco riggi5 Apr
      • Re: REG:ndb_restore failed in mysql cluster.periyannan natarajan6 Apr
        • Re: REG:ndb_restore failed in mysql cluster.franco riggi10 Apr