Tuesday, August 18, 2009

Show MySQL databases size

Counting all databases size in MySQL - original posted here.
select table_schema "Database",
sum( data_length + index_length ) / 1024 / 1024 "Size (MB)",
sum( data_free )/ 1024 / 1024 "Free (MB)"
from information_schema.tables
group by table_schema;

Sunday, August 9, 2009

Cross-browser printing iframe content

I found problem with printing iframe content in Opera. So here is my simple solution:
function print_iframe(s) {
var iframe = window.frames[s];

if(navigator.userAgent.indexOf("Opera") == -1) {
iframe.focus();
iframe.print();
} else {
var opera = window.open(iframe.location);
opera.opener.focus();
opera.print();
opera.close();
opera = null;
}
}