Technical guides and operational notes filed under Mysql.
Technical guides and operational notes filed under Mysql.
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 web server. Therefore, I need to begin it again…
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
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 ArticleA 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: L inux operating system. A pache HTTP server. M ySQL…
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