content_image/813515.jpg content_image/813516.jpg content_image/813517.jpg
directly. Because it does not make use of the management server, this utility can be used when the management server is not running, and even when the cluster has been completely shut down. 

## 23.4.23 ndb_restore — Restore an NDB Cluster Backup 

The NDB Cluster restoration program is implemented as a separate command-line utility ndb_restore , which can normally be found in the MySQL bin  directory. This program reads the files created as a result of the backup and inserts the stored information into the database. 

<img src='content_image/813515.jpg'>

## Note 

Beginning with NDB 8.0.17, this program no longer prints NDBT_ProgramExit: ...  when it finishes its run. Applications depending on this behavior should be modified accordingly when upgrading from NDB 8.0.16 or earlier to a NDB 8.0 later release. 

ndb_restore  must be executed once for each of the backup files that were created by the START BACKUP  command used to create the backup (see Section 23.5.8.2, “Using The NDB Cluster Management Client to Create a Backup” ). This is equal to the number of data nodes in the cluster at the time that the backup was created. 

<img src='content_image/813516.jpg'>

## Note 

Before using ndb_restore , it is recommended that the cluster be running in single user mode, unless you are restoring multiple data nodes in parallel. See Section 23.5.6, “NDB Cluster Single User Mode” , for more information. 

Options that can be used with ndb_restore  are shown in the following table. Additional descriptions follow the table. 

<img src='content_image/813517.jpg'>

