Dell Compellent Series 40 - Manual (Page 59)

51
Cleaning Up Data Collector Databases
Cleaning Up Data Collector Databases
To clean up a Data Collector database:
1 Do one of the following:
MySQL (all versions)
Enter the following SQL commands as an Admin user:
mysql> Drop Database compmsadb;
mysql> DELETE FROM mysql.user WHERE User = 'compmsauser';
mysql> FLUSH PRIVILEGES;
MS SQL (all versions)
Enter the following SQL commands as an Admin user:
Drop Database compmsadb;
EXEC SP_DropLogin 'compmsauser';
2 Reinstall the Enterprise Manager Data Collector.
Note For a Flat File system, reinstall the Enterprise Manager Data Collector. The flat file
is automatically cleaned up.