Are you tired of manually renaming MySQL tables, one by one, especially when dealing with a large number of them? In this guide, we’ll introduce you to a MySQL stored…

The post How to bulk rename table MySQL first appeared on Change Is Inevitable.

This procedure will split  a “;” separated column in to new fields preserving ids. This is very specific problem, lets check it with example. Consider a sample table test: And…

The post MySQL Stored procedure – Split Delimited string into Rows first appeared on Change Is Inevitable.

Well procedures mainly carried out working with information schema and it’s usage in stored procedure. Procedures are fairly simple and easy to understand. 1. Edit_table – following procedure executes queries to…

The post MySQL Stored procedure – Execute query if table or Column exists first appeared on Change Is Inevitable.

This procedure lists available database objects under passed database name. It lists present Tables, Views, Stored Procedures, Functions and Triggers under particular database. It also lists storage engine of tables.…

The post Stored procedure to Find database objects first appeared on Change Is Inevitable.

For monitoring replication we know a lot of tools and codes – but this one is different because I wrote it 😉 Well this is fairly simple php code for…

The post MySQL master master replication monitor with php code first appeared on Change Is Inevitable.

In this post we will look into the MySQL memory utilization estimation or calculation based on the global variables. Using a simple stored procedure call you can get the memory…

The post Calculate MySQL Memory Usage – Quick Stored Procedure first appeared on Change Is Inevitable.

Monitoring a replication is an important aspect. As replication includes multiple nodes, it is essential to track activity and status across all mysql servers involved in replication. To monitor replication…

The post Monitor multiple mysql replication using php: Updated first appeared on Change Is Inevitable.

“Show Slave Status” command has a last column “Seconds_Behind_Master”, which gives us idea about how much time slave is lagging behind master. It is an important to be considered parameter…

The post Replication slave lag monitoring using heartbeat and windows batch scripts first appeared on Change Is Inevitable.

What will you do if one day some one ask you to find single string in all databases, all tables and in all columns, In MySQL Database? This article presents a practical solution…

The post how to search / find through all databases, tables, columns in MySQL first appeared on Change Is Inevitable.

Upload Image to MySQL using PHP As a new-bie to php/mysql, I tried different stuffs. So here I’m with my php code for Image Upload to MySQL. Its a quite…

The post Upload Image to MySQL using PHP first appeared on Change Is Inevitable.