Setup and configure MySQL backup using Holland and Xtrabackup
Setting up a database backup is a primary task for database administrators and we see perl and shell scripts wrapped around few of the backup-tools in practice. With right tools…
Cannot connect to MySQL server on ‘localhost’: Cacti Error
FATAL: Cannot connect to MySQL server on ‘localhost’: Cacti Error – Solution to the issue while setting-up.
How-to extract from mysqldump | mysql-dump-splitter recipes
This post will answer how to extract database, tables etc from mysqldumpsplitter utility.
How to fix definer does not exist error 1449 MySQL
Explaining and providing solutions of MySQL error 1449: The user specified as a definer does not exist using SQL SECURITY INVOKER and DEFINER.
10 useful shell script code snippets | Linux
10+ useful code snippets of Linux shell scripts for how-to color, sendmail, log, change dir, parse parameters, loop, configuration file, switch..case and more.
How to Restore / point in time recovery using binary logs MySQL
In this post I will share a recovery scenario of a MySQL database restore from the binary logs. This post is also a good example of how we can achieve…