Lifelong Learner | CEO and Founder at Arystech | Cloud | Amazon Connect | Serverless | Infosec | DevOps
Lifelong Learner | CEO and Founder at Arystech | Cloud | Amazon Connect | Serverless | Infosec | DevOps
Compare directories for difference using diff command in linux. These parameters would give the list of files that are different in each directory recursively diff -qrbB /directory_one/ /directory_two/ > difference-brief.txt These parameters would give not only give list of differences,…
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…