Get table or DB size im Megabyte

Sometimes it is really useful to know how large a certain database table has become. With the following SQL statement you get a list of all tables of the currently connected database with their rounded size in MB:

This query selects all tables from all connected databases. If you want to select a certain […]

Batch resize images with ImageMagic

Recently I had to reduce the size of many images for uploading  them to a website. Unfortunately I didn’t find any tool like IrfanView on Ubuntu, which I’ve used for such problems in my Windows days. But there is a much smarter way to batch resize images on Linux. You simply can use the convert command from […]