Awk & sed Snippets for SysAdmins

Using GNUPlot to chart MySQL data

The following Korn shell function connects to a MySQL database and extracts specified data, which is then plotted as a function of time using GNUPlot.  Using correct syntax is critical. Note the use of single- …

Database operations with SQL and Korn shell

The following Korn shell function will read the a directory containing CSV data files named server_sysstat.20051119.csv with format:

Solaris boot disk copy

A sample procedure for installing PHP, MySQL and Apache2 on Solaris 8.

FTP script with nested function

An example of an FTP script with Korn shell.

Resetting Root Password under Solaris

The following document explains how to change an unknown root password on a Solaris system. Use this only for disaster recovery purposes. Please be sure to read the Notes section below if you run into …

Resetting Admin Passwords on Windows

Resetting Local Administrator/User Passwords on Windows NT/2000/XP/2003
The following document explains how to change an unknown password for any local account (including Administrator) on a Windows NT/2000/XP/2003 system. Use this only for disaster recovery purposes.
Requirements:
1.Physical access …

Unix Commands Summary

 
awk/nawk [options] file scan for patterns in a file and process the results
cat [options] file concatenate (list) a file
cd [directory] change directory
chgrp [options] group file change the group of the file
chmod [options] file change file …

Moving filesystems with ufsdump

to move /opt on new partition (disk or file system)
1) from system prompt: format –> partition –> label
2) newfs -v /dev/dsk/c0t1d0s1 (target location)
3) mkdir /new_dir
4) mount /dev/dsk/c0t1d0s1 /new_dir
5) cd /new_dir
6) ufsdump 0f – /opt | …

Copying directories using tar and rsync

Best Diets Overall 2023

If your goal is to manage your weight long term and eat healthfully, try one of these science-backed diets that work. Each earns top marks from our panel of leading medical and nutriton …

Using more on multiple outputs

Here’s the correct way to page four commands so they’re all controlled by “more”:

Find largest files

How to find the largest files in the directory tree on Solaris.

Increase swap space

Best Diets Overall 2023

If your goal is to manage your weight long term and eat healthfully, try one of these science-backed diets that work. Each earns top marks from our panel of leading medical and nutriton …

Count users with “last”

Here is a quick example showing how to count users logged in on a particular date using the “last” command on Linux.

To display file’s modification, last access, etc

Display a file’s modification, last access and other attributes on Solaris.

Using NetBackup to restore boot disk

enable “Rename hard links”
disable “Rename soft links”
if root of destination drive is mounted as /destination/ then select “Restore to alternate path: from / to /destination/ , Restore search path
This is the alternate path for everything: …

Create tarball

The Unix tar command creates an archive of files and directories while preserving directory structure, file permissions and ownership information. This command is ideally suited for creating backups of most types of data. Many open-source …

Move USER to new primary group

A sample process for moving a user to a new primary home group on Solaris.

Check if Solaris supports 64-bit applications

How to determine if your installation of Solaris supports 64-bit applications.

Unix Files Transferred To CD

In our example we were requested to archive a 741 mb directory to CD. The source data resided on a Unix data server.

How to exercise during Ramadan: ‘I’m a Muay Thai champion and PT, here are my tips’

Here’s an example of how to mount a cdrom on Solaris from a remote ISO image via NFS.

Tips To A Healthier Dog

Useful awk code snippets for your sysadmin tasks.

Copy directory structure and files with cpio

A basic command to copy directory structure and contents using cpio.