Recently I got the system which has MySQL server version 5.1 was running. It was good chance for me to reproduce the issue and show practical answer on question asked on stackoverflow. Operating System: CentOS 6.5 Arch : x86_54 Symptom MySQL service failed to start after upgrading from MySQL 5.1 to 5.6 version. Given below […]
mysql
How to install MySQL Server 5.6 on CentOS 7 / RHEL 7
In this tutorial we will learn, how to install MySQL Server 5.6 on CentOS 7 / RHEL 7 . In our previous post, we have installed MySQL Server 5.6 on CentOS 6.x/RHEL 7.x. In CentOS 7/ RHEL 7 , now MariaDB is introduced as a defualt database. Still many Organisations/Company would like to continue with […]
mysqldump: Got error: 145: Table ‘./DB/table-name’ is marked as crashed
It was time to take backup of mysql database of my server. I run the command mysqldump with some options and found the error, ” mysqldump: Got error: 145: Table ‘./DB/table-name’ is marked as crashed and should be repaired when using LOCK TABLES ” I have seen this error before but not written on this […]
How to install mysql server 5.6 on Ubuntu 14.04 LTS ( Trusty Tahr )
In this practical we will learn, how to install mysql server 5.6 on Ubuntu 14.04 LTS ( Trusty Tahr ).At the time of writing this post, MySQL Server has 5.6 version as stable release (release date – 11 April 2014). MySQL is a open source relational database management system (RDBMS). It is popularly used in […]
Another MySQL daemon already running with the same unix socket
In this post ,I am sharing the error message ” Another MySQL daemon already running with the same unix socket “. The error found in our own sharadchhetri.com blog while restarting the MySQL server.It is at 6:55 PM IST,I noticed the weird error message on blog,”Error establishing a database connection”.I log into the server and […]
Set delay replication to MySQL slave server
In this tutorial we will learn how to set delay replication in MySQL Master Slave replication. After setting this configuration,slave server deliberately lag behind the Master server as per the delay time you have set. The MySQL server version 5.6 has this feature and it has some benefits which will discuss in this post. To […]