Error The Server Quit Without Updating Pid File
This detailed guide is mainly for FreeBSD, however the idea coincides for Linux. Every once a while, when I upgrade my FreeBSD box, the system prefers to shutdown my MySQL…
How to Restore One Database From All Database mysqldump
In this tutorial we are going to learn how to restore single MySQL database from a mysql backup file, which contains multiple databases. What if you backed up all databases…
How to install mytop on CentOS 7 to monitor MySQL processes
Mytop is an open source, command line tool used for monitoring MySQL performance. Mytop program provides a command-line shell interface to monitor real time MySQL/MariaDB threads, queries per second, process…
Install and Configure MySQL Workbench on Ubuntu Linux
MySQL workbench is a graphical application that lets us manage data and perform administrative tasks on MySQL databases. In this tutorial, we will see how to install the program on…
How to install LAMP Stack on kali linux
A LAMP Stack is a set of open-source software that can be used to create websites and web applications. LAMP is an acronym, and these stacks typically consist of: Install…
How to Recover from mysql log read failure
If you deal with MySQL master/slaves a lot you may run into the following error. Relay log read failure: Could not parse relay log event entry. To fix this you…
How to export/import MySQL database with correct character set on Linux?
To Export/Import MySQL database with correct character set on Linux export your database with the correct character set is important to avoid any kind of problems with data that has…