In this guide we will learn, how to install MySQL Server 5.7 on Ubuntu 14.04 LTS. We always recommend our readers to read release notes of every mysql. If you are specifically looking for MySQL Server 5.6 server installation , you can read our previous post. Our Environment Operating System : Ubuntu 14.04 LTS Arch: […]
mysql
how to change path of tmpdir in MySQL Server On Ubuntu
The post will explain , how to change the tmpdir in MySQL Server on Ubuntu. In the temporary directory for MySQL, generally temporary tables are stored. We generally change its path to make our mysql server performance better. Practical Tested On : It will works for other MySQL and Ubuntu version also.Our testing inventory is […]
Upgrading MySQL 5.1 to 5.6 service failed to start
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 […]
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 […]