MySQL Forums
Forum List  »  NDB clusters

How does ndb_restore work?
Posted by: Jeff
Date: September 19, 2005 02:42PM

I tried a restore test using ndb_restore test and found no data got restored.

The process used:
1) Take backup from mgm node:
ndb_mgm> start backup;
Waiting for completed, this may take several minutes
Node 2: Backup 2 started from node 1
ndb_mgm> Node 2: Backup 2 started from node 1 completed
StartGCP: 161400 StopGCP: 161405
#Records: 144367 #LogRecords: 0
Data: 45360608 bytes Log: 0 bytes


2) drop the 'test' database from the two sql nodes that I have.

3) recreate the blank 'test' database on the two sql nodes.

4) manually recreate the two tables that I have in the test database.

5) Go to the backup directory on the two sql node, run
# ndb_restore --backupid=2 --ndb-nodeid=2 --nodeid=2
Ndb version in backup files: Version 5.0.10

# ndb_restore --backupid=2 --ndb-nodeid=3 --nodeid=3
Ndb version in backup files: Version 5.0.10

6) Go back to the 'test' database and select from the tables. No record got restored.

Questions.
1. How does ndb_restore work?
2. Can I restore just one database instead of all databases?

Options: ReplyQuote


Subject
Views
Written By
Posted
How does ndb_restore work?
2740
September 19, 2005 02:42PM
2098
September 20, 2005 08:21AM
1937
September 21, 2005 09:18AM
1602
September 21, 2005 12:24PM
1769
September 22, 2005 02:15PM
1797
September 23, 2005 07:20AM
1498
October 04, 2005 09:09AM
4017
October 04, 2005 09:17AM
1858
October 04, 2005 05:41PM
1623
October 05, 2005 07:07AM


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.