Mysql commands

show databases

use super

mysql super

iireset
----------------------------

See what you get from these queries on the DSA:

mysql -P3308 nqrptr

select * from settings;

select * from parameters;

-----------------------------

mysql -P 3308 nqrptr < D:\settings.sql

---------------------------

You could start with

mysqlcheck --auto-repair -A

and see if that reports any corruption

 --------------------------------------------


d:\DBTools3>
DbbackupMT.exe netqosportal d:\backup
-------------------------------
Inactive interfaces script:

Hi Rob. Katie’s query redirected to output file would be a good start:

D:> Mysql –P 3308 reporter –e “Select RouterName, Name, Enabled, from_unixtime(LastData) from agents_all_view where LastData < unix_timestamp()-86400 and enabled=’Y’ order by RouterName” > d:\inactive.txt

 ----------------------------------