Tag MySQL

Query to show the size of the tables of a MySQL database. The output would be in MB and sorted in descending order. SELECT table_schema as `Database`, table_name AS `Table`, round(((data_length + index_length) / 1024 / 1024), 2) `Size in…

mysqldump is a command line utility used to perform logical backup of MySQL databases. mysqldump backs up schema objects and data. Backup Database  Syntax: mysqldump -h hostname -u username -p databasename > Example: mysqldump -h localhost -u dbadmin -p…

Download and install the repository # rpm -Uvh  Install phpmyadmin using yum # yum install phpmyadmin By default you can access phpmyadmin from localhost. You need to add the IP address of the host. Edit the file phpmyadmin.conf located at…