The database restore function for version 8 utilizes a faster, more efficient enterprise backup that is different from prior versions and must be done via a cli command. The user interfaces for the java applications and in Extreme Management Center OneView window don't have provisions to allow a database restore and can only be used to initialize the database to a default state.
The restore runs using the mysqlbackup_restore script in the <install directory>\scripts directory.
To restore the Management Center database backup:
- Ensure you are running the same version of Management Center used when creating the database backup on the Management Center server.
- Log into the system shell (via the local console or SSH) on the Management Center server as root on a Linux operating system or open a CMD prompt by selecting Run as administrator on a Windows operating system.
- Navigate to the scripts directory:
- On a Windows server, enter cd "<install directory>"\scripts.
- On a Linux server, enter cd <install directory>/scripts.
- Run the mysqlback_restore script:
- On a Windows server, enter mysqlbackup_restore.cmd "<full backup directory structure configured on Backup/Restore tab, including path>"
(e.g. mysqlbackup_restore.cmd "C:\Program Files\Extreme Networks\NetSight\backup\netsight_03272017/").
- On a Linux server, enter ./mysqlbackup_restore.sh <full backup directory structure configured on Backup/Restore tab, including path>
(e.g. ./mysqlbackup_restore.sh /usr/local/Extreme_Networks/NetSight/backup/netsight_03272017/).
Restoring older databases from prior versions created with the OneView or java client interface:
- Open OneView/Extreme Management Center
- In the tree on the left, select Administration
- Select Backup/Restore from the tabs on the right
If there are Legacy database files in the backup directory, the Restore section of the screen will populate as follows allowing you to restore a legacy database. This section will not allow you to restore enterprise backups that were created with the cli. Those must be restored via the section above using the cli commands.
Extreme Management Center's restore of Legacy backups supports 2 major revisions back. We have tested back to revision 6.3Note 2:
For enterprise backups you may only restore to the same version that you did a backup from. If for example you did a 220.127.116.11 backup using the enterprise backup cli, you can only restore that backup to version 18.104.22.168. If you used the backup button from OneView or the java client interface, the DB file will show up in the version 8.0 restore area and you can restore the DB to version 8.