Script to backup MySQL databases

Sometimes we need a automated system which will make the backup of our database server. But some of the Databases are unnecessary for us to make those backup. This script will help you to make backup of your database but you can exclude the database you don’t want to backup.

Continue reading…

 

Basic MySQL commands

Here I will describe some basic commands of MySQL. After login to the server console by SSH you can issue the below commands. Loing to MySQL

List all MySQL databases on the system.

Change to some database when you first connect to MySQL.

List all tables from the current database or from […]
Continue reading…

 

How to secure newly installed MySQL

Don’t you think that you have a security hole after a fresh installation of MySQL database? If don’t then Please try to login to your MySQL without any username and password. It will allow you to login. Here I will tell you how to protect that.

Continue reading…

 

MySQL replication status notification

Using the below simple bash script you can get an alert message from the replication server if replication is down or not working.

Setup this script in conrtab of Master server

Continue reading…