4.6.2.2 Simple complete restore

To perform a complete restore of a MySQL NDB Cluster from a backup with a given ID, follow the steps listed here:

1. Identify the backup to be used.

   In this example, we use the backup having the ID 4, that was created for mycluster previously in this section.

2. Wipe the MySQL NDB Cluster data.

   The simplest way to do this is to stop and then perform an initial start of the cluster as shown here, using mycluster:

   mcm> stop cluster mycluster;
   +------------------------------+
   | Command result               |
   +------------------------------+
   | Cluster stopped successfully |
   +------------------------------+
   1 row in set (15.24 sec)
   
   mcm> start cluster --initial mycluster;
   +------------------------------+
   | Command result               |
   +------------------------------+
   | Cluster started successfully |
   +------------------------------+
   1 row in set (34.47 sec)

3. Restore the backup.

   This is done using the restore cluster command, which requires the backup ID and the name of the cluster as arguments. Thus, you can restore backup 4 to mycluster as shown here:

   mcm> restore cluster --backupid=4 mycluster;
   +--------------------------------+
   | Command result                 |
   +--------------------------------+
   | Restore completed successfully |
   +--------------------------------+
   1 row in set (16.78 sec)