Comtech EF Data NetVue Release 1.1 User Guide - Manual (Page 206)

Advanced Configuration (System Display) Revision 3
NetVue User Guide MN-NETVUE
10–69
If all or some of those Parameter values must be cleared, see below for detailed instructions.
CAUTION: Only people with the appropriate skills should be allowed to manipulate
database contents directly. Incorrect changes made to the database can damage your
entire NetVue Cluster.
For one particular Element on a NetVue, execute this SQL delete statement:
DELETE FROM elementdata WHERE iEID = [Element ID, NOT preceded by the DataMiner ID];
For a particular Element, if you want to delete values of specific Parameters only, add a Parameter
restriction (“AND iPID = 102” or “AND iPID >= 100”) to the WHERE clause.
For all Elements on a NetVue:
1. Rename the elementdata table to elementdata_old by executing the following SQL statement:
ALTER TABLE elementdata RENAME TO elementdata_old
Or, if you are using MySQL Workbench, you can rename the table by doing these four steps:
a. Go to SQL Editor.
b. In Object Browser, go to sldmadb ‣ Tables ‣ elementdata.
c. Right-click elementdata, and choose Alter Table.
d. In the elementdata dialog box, enter another table name (e.g. elementdata_old) in the Name box
and click Apply.
2. Restart the NetVue Agent.
3. During the restart operation, a new, blank elementdata table is created.
4. If Steps 1 through 3 are successful, remove the old table by executing the following SQL statement:
DROP TABLE elementdata_old
10.9.1.4.1 Moving the MySQL data to another location
To move the MySQL data directory to another location, you must first copy the data to another directory,
and then change settings in both the MySQL Administrator and the my.ini file.
1. Stop NetVue.
2. In MySQL Administrator:
a. Go to Service Control and stop the MySQL service.
b. Go to Startup Variables and write down the contents of both the Base directory and Data directory
boxes.
3. If the data must be moved to a folder that does not exist, then create that folder.
4. Copy all data in the current Data directory to the folder that will become the new Data directory.
5. In my.ini, located in the Base directory, change the datadir parameter. If the current data directory is
C:/MySQLData/ , look for this line:
datadir="C:/MySQLData/