While using the mysqldump command in one of the MySQL server I got the error mysqldump: Error: Binlogging on server not active . Below given is the quick solution for it. Details of MySQL Server: MySQL Server: mysql-server-5.5.34 Error: Binlogging on server not active Note: The path of my.cnf file In CentOS and Red Hat…
This is a small tip to find mysql commands history without login into mysql server.When we login into MySQL server,generally we uses up and down arrow key to find the history of MySQL commands. Actually the MySQL commands history are saved in file called .mysql_history located in user’s home directory by which he/she logged into…
In this post we will know how to rename table in mysql using command line. It is basic and important command for MySQL database administration. We are doing this practical in MySQL server version 5.5.29. Syntax: Replace the table_name and NEW_TABLE_NAME as per your requirement. ALTER TABLE table_name RENAME NEW_TABLE_NAME Example: See the below given…
In this post we will learn about how to copy the existing table in mysql. The newly copied table does not have data means it will be blank but it has similar rows information from its parent table. After copying the table you have to insert the data by using INSERT command. Follow the given…
This is a simple mysql backup script.The script can be used manually as well as in crontab. Edit the below given script and provide the information required in the script. The script will take the backup in .sql format later it will compress the .sql file and in end send the mail about the status…
How to install pam_mysql in CentOS or Red Hat While working on some mysql authentication.I required pam_mysql. In CentOS 6.4 I found it was not available even in CentOS 5 it was not also. Again same method is applied. Download the EPEL repo. Step 1: Install latest EPEL Repo rpm -ivh http://dl.fedoraproject.org/pub/epel/6/i386/epel-release-6-8.noarch.rpm Step 2: Now…
MySQL Workbench is a integrated tool for MySQL. The MySQL workbench gives a graphical interface to user through which user can easily manage many MySQL Administration task. The tool can be install in Windows,MacOSX and Linux. As well as its source code is also available.The MySQL Workbench is easy to install in Windows,MacOSX and Linux…
When you work on mysql server and hit some command in mysql prompt,you get the output in horizontal way. For eg. I hit the command, select emailid from linuxtable where user = ‘sharad’; and this table has lots of fields . In that case the output looks weird. Rather than seeing the output Horizontally in…
In this tutorial we will learn about how to set default storage engine to MyISAM to InnoDB or vice versa. Since the change in MySQL default storage engine as InnoDB there are many Database Servers which are still running in MyISAM. The change in Default storage engine come after MySQL 5.0 and later versions. In…
MySQL server comes with many engines,earlier MyISAM was default storage engine but from MySQL version 5.5 and later InnoDB now become a default storage engine. Yet,you should know what is the default storage engine running in mysql server. It might be possible any database admin has changed to MyISAM or INNODB as default storage engine…
Today we will learn about 4 basic commands in mysql server which are related to manage the database.These 4 commands are important for any Mysql Database administrator.The post is mainly written for beginners of MySQL database administration. All the data are saved in some database. These Databases have some name hence the basic thing is,we…
send email after mysql backup through bash script in simple way In Facebook group one of the user asked this question “how to send email after mysql backup through bash script”. If you know bash scripting a bit it is just a one liner. It can be write in more advanced form but here I…
How to change mysql data directory in Ubuntu In this tutorial we will learn how to change the default path of mysql data directory. The mysql server bydefault keep the data in /var/lib/mysql . If you want to change its path follow the given below steps. Lets have an overview for changing mysql data directory…
In this post we will learn about,how to install mysql server in RedHat and CentOS. MySQL is a relational database management system (RDBMS), and ships with no GUI tools to administer MySQL databases or manage data contained within the databases.Read More About MySQL Server Default Port Number of MySQL : 3306 (TCP) Install the MySQL…