Technical articles and infrastructure guidance tagged mysql.
Technical articles and infrastructure guidance tagged mysql.
MySQL server being offline can cause a variety of issues for website and application owners who rely on the database to store and retrieve data. If your cPanel MySQL server is currently offline, there are a few…
Read Article
Because of Bug in the CPanel release lots of our client are facing issue that MySQL is showing down in cPanel interface. But the MySQL/MariaDB was still running. It’s only the cPanel interface that was showing the…
Read Article
to install the MariaDB database manager and to validate which components are available for the MariaDB databases we will execute the following command. We can see the various options available. ls -al…
Read Article
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 in your MySQL/MariaDB Server using…
Read Article
Attempts to manage customer’s MySQL databases produce errors: Error: Connection to the database server has failed because of network problems: Try to establish connection failed The MySQL server is marked in red on the…
Read Article
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 list and…
Read ArticleMySQL 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 Ubuntu 18.04 (Bionic Beaver). In this…
Read ArticleIf 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 will need to reset the slave and request a new copy of the…
Read Article
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 non English characters within the…
Read Article
In this post, we will learn how to install MySQL on Ubuntu 18.04 Before proceeding, the user must have sudo privileges using which you are logged in. Installing MySQL 1) Run updates for indexing packages $ sudo apt…
Read Article