google-code-export / mycheckpoint

Automatically exported from code.google.com/p/mycheckpoint
1 stars 3 forks source link

Export parameter change tracking as html code #37

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
What is the feature request?
Currently myCheckPoint documentation explain that we can generate parameter 
change tracking report as a simple query "SELECT * FROM sv_param_change;" who 
generate a one row sql result. Documentation show us a formatted result :
+---------------------+-----------------+-----------+-----------+
| ts                  | variable_name   | old_value | new_value |
+---------------------+-----------------+-----------+-----------+
| 2009-11-04 13:00:01 | max_connections |       500 |       200 |
+---------------------+-----------------+-----------+-----------+

In real case, this query ran from command line given us a flat result like this:
> mysql -umycheckpoint -pmycheckpoint dbname --execute="SELECT * FROM 
sv_param_change" --silent > paramchange.html
  ts      variable_name   old_value       new_value
  2012-06-18 11:35:01     max_connections 200     100

Redirecting this result to a file isn't exploitable as human report easily.

Solution: In documentation, insert following code to explain how to export 
directly result to html code:
> mysql -umycheckpoint -pmycheckpoint dbname --execute="SELECT * FROM 
sv_param_change" --silent --html > paramchange.html
<TABLE 
BORDER=1><TR><TH>ts</TH><TH>variable_name</TH><TH>old_value</TH><TH>new_value</T
H></TR><TR><TD>2012-06-18 
11:35:01</TD><TD>max_connections</TD><TD>200</TD><TD>100</TD></TR></TABLE>

How will this change current behavior?
Just export result formated in html code

What parameters/options will be required?
--html in mysql command line

What version of the mycheckpoint are you using?
r223

What version of the MySQL are you using?
5.5.16-log

On what operating system?
Linux RedHat 5 Enterprise

Thanks

Original issue reported on code.google.com by tda...@gmail.com on 18 Jun 2012 at 11:51