Recently I happen to install MySQL on Mac OS X (Darvin Kernel). Below are the quick 5 steps to accomplish the task. Step 1: Check Mac Version Very first step…
The post Installing MySQL On Mac OS X (Darwin Kernel) first appeared on Change Is Inevitable.
Moving, copying or renaming database is a very basic activity. I have just noted a few commands for reference to quickly follow the required operation. 1. Rename database on Linux…
The post Steps to Move Copy Rename MySQL Database first appeared on Change Is Inevitable.
This post covers the basic information of files that MySQL Server uses / creates for various tasks. Update: Various files in MySQL 8.0 Refer following updated article for latest information…
The post MySQL related file types and basic information first appeared on Change Is Inevitable.
In mysql we have — , /* and /*! comments. This post is mainly about very basic c-style comments. /*! : C-Style comments in MySQL We normally see comments in…
The post SQL syntax with /*! c-style comments in MySQLdump first appeared on Change Is Inevitable.
There are set of commands that MySQL itself interprets. You may use “help” or “\h” at the mysql> prompt to list them. Below are the 5 most useful MySQL Command…
The post 5 useful MySQL Command Options-pager-prompt-rehash-tee-system first appeared on Change Is Inevitable.
I’m having RHEL 5 (32-bit) and MySQL-5. I was trying to check how much is the Memory Utilization limits for MySQL 5 on 32bit OS. We can easily calculate the…
The post MySQL Memory Usage Limits on 32 bit Linux first appeared on Change Is Inevitable.
Creating scheduled backup using administrator is an easy task. Follow the GUI and you’re done. But I observed something different! MySQL Version: 5.0.83 Community MySQL Administrator: 1.2.17 Machine: Intel P4,…
The post Scheduled Backup MySQL Administrator & Windows Scheduler – Odd first appeared on Change Is Inevitable.
At times you need to install multiple MySQL instances on same machine. This article is a brief step-by-step tutorial on the subject task which is divided into the following main…
The post Install 2 MySQL Server instances replication on Windows first appeared on Change Is Inevitable.
In this post we will see importance of replication related variables auto_increment_increment & auto_increment_offset with respect to MySQL Master Master setup. Consider we’ve already set a master-master replication. Now create…
The post MySQL Master Master Replication and auto_increment_increment / auto_increment_offset first appeared on Change Is Inevitable.
MyISAM InnoDB Default since version 3.23 Relatively newer Files storage: FRM: table definition, MYD: Actual Data MYI: Index File FRM: table definition .ibd file (concept of table space) or single…
The post Difference MyISAM and InnoDB Storage Engines Mysql first appeared on Change Is Inevitable.