MySQL paging or scrolling

We can use the following to prevent query results from scrolling to the end of the results;

\P /usr/bin/less

or alternatively;

pager less -S

This will act like grepping a file to less (cat somefile | less)

\n or nopager will return to normal.

Additionally, we can use the \G at the end of a query to output results vertically, say we have too many columns. For example show slave status\G;

Linux Routing Table

From route -n

monit summary showing "error connecting to the monit daemon"

I've had this several times and while it's been an issue, it's never really bothered me enough to investigate. I have however since found this to be a result of there being no "lo" interface up. when running ifconfig it was missing, so simply bringing this up by ifup lo resolved.

Clear bash history

history -c && history -w

[source]

XFCE desktop configuration file

 can be found here: /usr/share/applications/appName.desktop

To find out a directory size in Linux

sudo du -sh /path/to/folder

Network Configuration in OpenBSD

Edit /etc/rc.conf

Change

ifconfig_em0="DHCP"

to

ifconfig_em0="inet 192.168.56.105 netmask 255.255.25.0"

and add

defaultrouter="192.168.56.1"

edit /etc/resolve.conf as per Linux and then do;

service netif restart && service routing restart

[source]

Ping on OpenVMS

 UCX PING xxx.xxx.xxx.xxx

Copy file To Remote using ssh

scp

To copy a file from one local machine to a remote machine using ssh, do the following;

scp /local/path/to/file username@ip_address:/path/to/remote/destination

or if we wish to get a file from a remote machine to the local machine, we can do;

scp username@ip_address:/path/to/remote/file /local/path/to/destination

 

Linux Serial Ports

TODO

[source]