System

Display result of command line query vertically

vertical output of your MySQL query when executing it from the console

Show MySQL table columns

get a list of table columns using a MySQL query

Compressing MySQL database dump

easily compress MySQL backup dumps using the linux shell

Import a compressed database dump

how to import a compressed MySQL dump with a single command

Create database dump without locking any tables

avoid table locks when creating a database dump file

MySQL table maintenance

how to keep your MySQL tables in a good condition

Group by and strict ONLY_FULL_GROUP_BY mode

potential problem caused by MySQL strict mode ONLY_FULL_GROUP_BY

Find the database with the biggest size

find the biggest mysql database in your system with a simple query

Display list of MySQL User Accounts

How to see all MySQL Users

Automated MySQL Backups

automated mysql backups using mysqldump