Managing databases via Linux shell is not a big deal. And we all are familiar with MySQL databases backup and restoration via CLI (Command Line Interface) using mysqldump and mysql commands. This is explained here >> Managing MySQL database backup…
Tag: MariyaDB
How to monitor MySQL databases using mytop – CLI tool
In this article I’m explaining the usage of a smart command-line tool “mytop.” Which is similar in look to the basic resource monitoring tool “top.” By using this command, you can monitor the MySQL queries lively. There are a lot…
List all MySQL databases from Linux command line
Is it possible to get databases details from server command line? Yeah!! if there is a way to list and sort out the database details from server CLI (command line interface), it’ll speedup your troubleshooting procedure. We can use the…
Repository details for MariaDB – CentOS 5, 6 & Redhat 5, 6
To install the MariyaDB on your server which has CentOS you must have a repository for MariyaDB. Do follow the steps below to create a repo for MariyaDB. CentOS Step 1 : Login to server via SSH as root. Step…