Steps to Move Copy Rename MySQL Database
Kedar
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…
Browsing Category
MySQL-Articles
78 posts
MySQL related blog posts
MySQL related file types and basic information
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…
SQL syntax with /*! c-style comments in MySQLdump
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…
5 useful MySQL Command Options-pager-prompt-rehash-tee-system
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…
How to Load Delimited Data CSV Excel to MySQL
Loading CSV to MySQL or any delimited data files to MySQL database is a very common task frequently questioned about and almost every-time LOAD DATA INFILE come into rescue. I’ll…
MySQL Memory Usage Limits on 32 bit Linux
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…