MySQL – Using “Load Data” Statement

Background Let us load data into our MySQL using it's native "Load Data" statement. Outline Data Source Identify Data Source Review Data Download Data Tools CURL Prepare Target Storage Create Tables Create Staging Table Create Actual Table Load Data Load data into staging table Move data from staging table into actual table Tasks Data Source … Continue reading MySQL – Using “Load Data” Statement

MySQL:- Select / INTO File

Background Wanting to extract data out of MySQL. Chose to use select along with "into outfile".   Outline Preparation Configuration Review Process SQL Review Data Tools cat Tasks Preparation Configuration Configuration - Review Let us review the pertinent MySQL Engine configuration. Outline System Configuration secure_file_priv Folders where File I/O can occur Tasks SQL SQL - … Continue reading MySQL:- Select / INTO File

Bash – Reading File

Background Now that we are able to run Bash on a Windows machine, it is even more reason to be aware of it.   Read a File Tradition Reading a file usually follows the following sequence:- Open File for reading Read line If EOF exit Process Read Line Read Next Return to EOF check   … Continue reading Bash – Reading File

GoLang – Availing on Linux

Background Let us avail the go runtime on our system.   Lineage OS Microsoft - MS Windows Link   Linux Though my primary OS is MS Windows, I play around a bit with Linux, as well. Options There are a couple of options for availing go on a Linux system. The options include:- rpm Repositories … Continue reading GoLang – Availing on Linux

Linux – CentOS – Set Timezone

Background Playing around with Linux, queried the system for the current time, and noticed it is a bit off.   OS OS - Linux - CentOS Our OS is CentOS/Version 8. Command hostnamectl We can issue hostnamectl, to get the OS Name and Version. Output Outline timedatectl timedatectl status timedatectl list-timezones timedatectl set-timezone timedatectl show … Continue reading Linux – CentOS – Set Timezone

Linux – File System – Listing File Systems

Background What is the File System on our disks? Outline Commands df ( Disk Free ) lsblk ( List Information on the block devices ) lshw ( List Hardware ) file ( File Command ) mount ( List Mount Points ) blkid ( List Information on Available Block Devices ) System Configuration File /etc/fstab Commands … Continue reading Linux – File System – Listing File Systems

Linux – CentOS /v8 – Avail Python/v2

Background Let us get Python version 2 to be the default Python version on our machine. Outline List installed Python Versions If not installed, Install Python version 2 Review Installed Locations Set Python Version 2 as the default version of Python Confirm Current Version of Python List Installed Python Versions Outline alternatives compgen alternatives Outline … Continue reading Linux – CentOS /v8 – Avail Python/v2

Linux – OS – Bitness

Background Let us figure out the bitness of our Linux OS. Outline Commands lscpu Commands lscpu Syntax Sample Output Output - Image Output - Textual Explanation Architecture Meaning:- Processor ( Hardware ) Common Values x86_64 64-bit CPU CPU op-mode(s) Meaning:- Based on OS Installed, CPU Operating Mode ( Software ) Common Values 32-bit, 64-bit Supports both … Continue reading Linux – OS – Bitness

Install Powershell on Linux/CentOS

Background Back playing around with a Linux box and wanted to see if it is any easier for me to understand the steps for installing Powershell. Outline Configure Source Repositories Review available Microsoft Repository for your OS/Version ( https://packages.microsoft.com/config/rhel/ ) Redhat Repository - Local Review "Local" Redhat Repository Is Microsoft repository registered? If Microsoft Repository … Continue reading Install Powershell on Linux/CentOS

Linux:- id command

Background In Linux, the id command displays a user's group names.   Output Here is information offered Attribute Meaning Sample uid User ID uid=1002(daniel) gid Group ID gid=1002(daniel) groups Groups groups=1002(daniel),10(wheel) Syntax Sample Sample-01 Command Output Image Textual Explanation User Id Sample uid => 1002 daniel Group ID  Sample gid => 1002 daniel Groups Sample … Continue reading Linux:- id command