Ads
Quick installation of mysql-utilities:
Step 1: Update system:
sudo apt-get update
Step 2: Install: mysql-utilities
Ater updaing the OS run following command to install the packae:
sudo apt-get install mysql-utilities
Package Details | |
| Package: | mysql-utilities |
| Version: | 1.6.3-1 |
| Maintainer: | Ubuntu Developers |
| Home page: | https://launchpad.net/mysql-utilities |
| Description: | collection of scripts for managing MySQL servers MySQL Utilities is both a set of command-line utilities as well as a Python library for making the common tasks easy to accomplish. The library is written entirely in Python, meaning that it is not necessary to have any other tools or libraries installed to make it work. . MySQL Utilities are intended to make working with servers easier. It is part of the MySQL Workbench. . This package provides the following utilities: mysqlauditadmin : maintain the audit log mysqlauditgrep : search an audit log mysqlbinlogmove : move binlog files to a different location mysqldbcompare : check two databases and identify any differences mysqldbcopy : copy databases from one MySQL server to another mysqldbexport : export a list of databases in a variety of formats mysqldbimport : import object definitions or data into a database mysqldiff : identify differences among database objects mysqldiskusage : show disk usage for one or more databases mysqlfabric : server farm management framework mysqlfailover : automatic replication health monitoring and failover mysqlfrm : show CREATE TABLE from .frm files mysqlgrants : privilege display utility mysqlindexcheck : check for redundant or duplicate indexes mysqlmetagrep : search MySQL servers for objects matching a pattern mysqlprocgrep : search MySQL servers for processes matching a pattern mysqlreplicate : setup replication among two MySQL servers mysqlrpladmin : administration utility for MySQL replication mysqlrplcheck : check prerequisities for replication mysqlrplms : establish a multi-source replication topology mysqlrplshow : show slaves attached to a master mysqlrplsync : check the data consistency between master and slaves mysqlserverclone : start a new instance of an existing MySQL server mysqlserverinfo : display common diagnostic information from a server mysqluc : command line client for running MySQL Utilities mysqluserclone : copy a MySQL user to new user(s) on another server |
| Distro: | Ubuntu 17.04 |
| Release: | |
| Repo/Section: | universe/database |
How to install mysql-utilities on Ubuntu 17.04?
First of all update your system with the command:
sudo apt-get update
Ads
Above command will download the package lists for Ubuntu 17.04 on your system. This will update the list of newest versions of packages and its dependencies on your system.
After downloading the latest package list with the help of above you can run the installation process.
If mysql-utilities is not installed on your compter then the command 'dpkg -L mysql-utilities' will give followin error.
deepak@deepak-VirtualBox:~$ dpkg -L mysql-utilities dpkg-query: package 'mysql-utilities' is not installed Use dpkg --info (= dpkg-deb --info) to examine archive files, and dpkg --contents (= dpkg-deb --contents) to list their contents. deepak@deepak-VirtualBox:~$
Installing mysql-utilities:
After system update use the following command to install mysql-utilities:
sudo apt-get install mysql-utilities
Above command will confirm before installing the package on your Ubuntu 17.04 Operating System. If you are not already logged in as su, installer will ask you the root password. After completion of the installation you can use the package on your system.
How to uninstall/remove mysql-utilities from Ubuntu 17.04?
Now we will see the commands for uninstalling the mysql-utilities from Ubuntu 17.04. For uninstalling this package you can easily use the apt command and remove the package from Linux Operating System.
To remove the mysql-utilities following command is used:
sudo apt-get remove mysql-utilities
Following command is used to remove the mysql-utilities package along with its dependencies:
sudo apt-get remove --auto-remove mysql-utilities
This will remove mysql-utilities and all its dependent packages which is no longer needed in the system.
Completely removing mysql-utilities with all configuration files:
Following command should be used with care as it deletes all the configuration files and data:
sudo apt-get purge mysql-utilities
or you can use following command also:
sudo apt-get purge --auto-remove mysql-utilities
Above command will remove all the configuration files and data associated with mysql-utilities package. You can can't recover the delete data, so, use this command with care.
