Restoring the database only (legacy)

If you do not use the Taskbar Utility to restore a DMA, there are two ways you can restore a legacy MySQL database:

• by restoring the MySQL database dump, or

• by manually copying the data files.

Note

For information on how to restore other self-hosted data storage nodes, see:

• OpenSearch: Configuring OpenSearch backups
• Elasticsearch: Taking and restoring snapshots
• Cassandra: Standalone Cassandra Backup tool

If you are using Storage as a Service, there is no need to restore the database. If you want to restore your DataMiner Agent on a new (virtual) machine, contact staas@dataminer.services to make sure your new setup is connected correctly.

Restoring a MySQL database dump

1. If it is not running yet, start the MySQL service.

2. Navigate to the C:\Skyline DataMiner\Backup\ directory:

   • To perform a full database restore, double-click {5B8F34AF-1656-4c02-94EE-CF028054602D}.bat.

   • To restore only the element configuration data (if the backup was saved with the Configuration backup setting), double-click {ELEMENTDATA-1656-4c02-94EE-CF028054602D}.bat.

The restore operation, displayed in a command window, can take up to several hours depending on the size of the database dump and depending on the performance of the hard disks. Unfortunately, there is no progress indication, but it is possible to watch the growth rate of the SLDMADB directory. The ultimate size of that directory will be about the same as the size of the dump file located next to the batch file you double-clicked.

Note

If the restore operation does not start, then open the batch file in Microsoft Notepad, and check the location of MySQL. Depending on the MySQL version, the location should be either C:\MySQL\bin\ or C:\Program Files\MySQL\MySQL Server 5.0\bin\.

Copying MySQL data files manually

When both the original and the destination server run the exact same version of MySQL, you can restore the database simply by copying the data files.

1. Make sure that both the original and the destination server run the exact same version of MySQL.

2. Make sure that the MySQL service is stopped.

3. Copy all files from the SLDMADB directory of the original server to that same directory of the destination server.

   Depending on the MySQL version, this directory will be located in C:\MySQL\Data\ or in C:\Program Files\MySQL\MySQL Server X.X\data.

4. Start the MySQL service.