Getting the size of a MySQL database

This is the command to get the size of the MySql database

SELECT table_schema "Data Base Name",
  sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB",
  sum( data_free )/ 1024 / 1024 "Free Space in MB"
  FROM information_schema.TABLES
  GROUP BY table_schema;

Learning SQL the interactive way

To learn SQL the interactive way, use the site

http://sqlzoo.net

Manually starting Microsoft File Transfer Manager

Here's how to launch the Microsoft File Transfer Manager manually.

%SystemRoot%\Downloaded Program Files\TransferMgr.exe

Removing the OzioGallery footer

When Ozio Gallery is used within Joomla pages, the component displays a footer
OzioGallery2 by Joomla.it

If you search the source, you will not find the text as it is encoded (with base 64) within
“\administrator\components\com_oziogallery2\css\ozio.css”

1. Use http://ostermiller.org/calc/encode.html to decode the encoding in the css file.
2. Then remove the text that is not wanted and encode again.
3. Then paste it back to the css file, replacing the original text.

Note: For OzioGallery3, the folder structure seems to have changed. The ozio.css file for OzioGallery3 is located within the folder "administrator\components\com_oziogallery3\assets\css".

Converting man pages to pdf

Issue this command at a Linux shell to convert the
man -t <manpage_name> ¦ ps2pdf - > <manpage_name>.pdf

Note: The "-t" switch calls in the "groff" utility to convert the man output to Postscript format

e.g. man -t ls ¦ ps2pdf - > ls.pdf