Mysql Archives | 24x7serversupport.com/blog

March 20, 2021

Categories

How to repair MySQL databases and tables on LINUX servers

In this article, we wish to provide you some helpful understandings on ways to repair work MySQL data source and table. This is most likely among […]

March 10, 2021

Categories

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 […]

May 3, 2020

Categories

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 […]

April 1, 2020

Categories

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, […]

March 28, 2020

March 28, 2020

Categories

Mysql

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 […]

March 19, 2020

March 19, 2020

Categories

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 […]

June 30, 2019

Categories

Mysql

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. […]

June 30, 2019

Categories

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 […]