MySQL Intravue FAQs
The MySQL folder has gigabytes of data, how to I make it smaller?
Can I export events from the event log
Return to Main FAQ page.
The MySQL folder has gigabytes of data, how to I make it smaller?
Your C:\\MySQL\\data folder may contains files that start with "mysql-bin", like mysql-bin.0000005.
There files are used by mysql for transactions when Windows' resources are low in a feature not used by IntraVUE.
You should comment out two lines in the c:\\MySql\\my.cnf file. It is usually best to open WordPad and then use File/Open to edit the file.
Put a # sign in front of the two line as shown below.
# log-bin=mysql-bin
# binlog_format=mixed
Now Stop the mysql service using the Windows Service dialog. This will cause the autoip i-server service to also stop.
Delete all the mysql-bin.0000xx files in the mysql\data folder.
Start the mysql and autoip i-server services.
The files will not be created anymore.
Note: Starting with Intravue version 2.1.0c5, these lines are commented out of the my.cnf file if you chose to replace mysql.
Can I export events from the event log
You may wish to look at Intravue events in a text file or spreadsheet.
You can do so from a DOS command prompt.
It is easiest if you run the DOS command prompt in the c:\\mysql\\bin folder.
The basic syntax to show the results on the console is:
mysql intravue < filename.sql
The basic syntax to save the results in a file (redirect) named save_file.txt is:
mysql intravue < filename.sql > save_file.txt
You can create several .sql files to get different events from intravue.
- To get all events sorted by IP address, create a new .sql file with notepad having one line
select RPAD(EventId,5," "), RPAD(Occurred,21," "), RPAD(IpAddress,16," "), Description from event ORDER BY IpAddress, EventId ;
The RPAD forces the results to have a certain number of spaces.
- To get all events into a CSV file (don't use the redirect command line for this one)
select * from event INTO OUTFILE 'events.csv' FIELDS TERMINATED BY ',' LINES TERMINATED BY '\\r\\n';
Note: the csv file will be saved in the mysql\\data\\intravue folder.
If you are familiar with mysql there is a lot more you can do.
In the future, it will be easier to get information like this from the Intravue user interface.