MySQL Forums
Forum List  »  NDB clusters

ndb_restore problem!!
Posted by: alan peng
Date: December 20, 2006 11:34PM

I use command of ndb_mgm -e "START BACKUP" to backup mysql database,
when I delete data of one of table,
then try use ndb_restore to Recovery .
I found that data rows had lost.
Could anyone point me what happen and how to resolve.

thanks,
alan

1.
mysql> select count(1) from xet_epaper;
+----------+
| count(1) |
+----------+
| 34 |
+----------+
1 row in set (0.24 sec)



2.
mysql> delete from xet_epaper;
Query OK, 34 rows affected (0.24 sec)



3.
[root@localhost ~]# ndb_mgm -e "START BACKUP"
Connected to Management Server at: 192.168.1.1:1186
Waiting for completed, this may take several minutes
Node 2: Backup 4 started from node 1
Node 2: Backup 4 started from node 1 completed
StartGCP: 182083 StopGCP: 182172
#Records: 1411129 #LogRecords: 0
Data: 2110575468 bytes Log: 0 bytes



4.
[root@database1 BACKUP-4]# /usr/local/mysql/bin/ndb_restore -c 192.168.1.1 -n 2 -b 4 -r ./
Ndb version in backup files: Version 5.0.27
Connected to ndb!!
.
.
.
.
.
NDBT_ProgramExit: 0 - OK



5.
mysql> select count(1) from xet_epaper;
+----------+
| count(1) |
+----------+
| 15 |
+----------+
1 row in set (0.24 sec)

Options: ReplyQuote


Subject
Views
Written By
Posted
ndb_restore problem!!
1316
December 20, 2006 11:34PM


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.