Simple MySQL / MariaDB Backup- Published on
mysqlThere are many ways to back up a MySQL or MariaDB server. Some ways include using mysqldump, mydumper, LVM Snapshots or XtraBackup. However, any robus...
mysql - Posts
Simple MySQL / MariaDB Backup
mysql- PROBLEM You have an existing server that runs a MySQL database (either on EC2 or not) and you would like to replicate this server with a Amazon RDS M...
Upgrade MySQL 5.5 to 5.6 on EC2/CentOS/RHEL
mysql- Published on
PROBLEM You would like to upgrade MySQL 5.5 to MySQL 5.6 on an existing server that uses the YUM software package manager. SOLUTION Just enter the...Delete All Binary Logs for MySQL
mysql- Published on
Today I discovered that one of my servers mysteriously ran out of disk space. I ran the following Linux command to find all the biggest files and fol...- I just spent a fair amount of time setting up MySQL replication between two servers encrypted by SSL (using MySQL 5.1.73). I struggled with fixing a ...
- If you are using Linux, there is simple way to check if a user exists in MySQL: echo `mysql -u root -p**[your root password]** -e 'use mysql; SELECT ...