Category ITOPS

Overwrite Local Files with Git Pull

If you need to discard the changes you made to your local environment, you can pull the remote branch code. To overwrite the local files from the remote branch: For more git related screwups, check out

Getting started with Chocolatey

What is Chocolatey? Every time you work on a Linux machine, you can quickly install applications using apt-get or yum. When you switch to Windows and have to install an application like Notepad++ or 7-Zip, you go to the website,…

Size of tables of a MySQL database

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…

MySQL Backup and Restore

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…

Cannot add VMFS datastore to ESXi host

Inaccessible Virtual Machines: If your virtual machines are inaccessible, that means that the vSphere client is not able to reach the *.vmx file. Check in your storage if your datastore is available. Unable to add datastore: If your VMFS store is missing…