backup · Linux · MySQL

Backup your MySQL/MariaDB database easily using Percona XtraBackup


Over the years I have looked around for easy to use MySQL database backup tools that I can quickly and reliably automate. I’ve tried many unsatisfactory solutions but finally I have found something I am happy with, Perscona’s XtraBackup. Unfortunately for Windows users this is a Linux only solution. Percona is an enterprise focused database company with… Continue reading Backup your MySQL/MariaDB database easily using Percona XtraBackup

Linux · MySQL · Server · Windows

MySQL lower/UPPER casing and ISO 8859, Unicode, UTF-8, UTF-16, UTF-32 Character Set Collations


By default MySQL uses the collation of latin1_swedish_ci character set for all columns. First off in case you are wondering the ci after the second underscore means case insensitive. All SQL queries targeting this column will ignore the letter case of the query values and the field data. Other collations that end with cs are case… Continue reading MySQL lower/UPPER casing and ISO 8859, Unicode, UTF-8, UTF-16, UTF-32 Character Set Collations