By Fekete Zoltán , 22 May, 2019

Save your settings, and run commands like this to install a single set to your system:

- save your settings first
# tar -cvJpf etc.tar.xz /etc
# tar -Jxvpf base.tar.xz -C /
- do the same with other sets except for etc and xetc

# etcupdate -av -s etc.tar.xz -s xetc.tar.xz
# postinstall fix

Then reboot to be on the safe side.

By Fekete Zoltán , 30 April, 2019

You have a machine (a master host) with several idividually installed packages. You want those packages to be rebuilt somewhere else (slave host). Do this:

1. On the master host
# pkg_info -Q PKGPATH -a > pkgs_i_want_to_have
2. Copy the generated file to the slave host, and issue as root:
# cat pkgs_i_want_to_have | (while read pp ; do cd /usr/pkgsrc/$pp ; make && make bin-install ; done)

Simple enough, eh?

By Fekete Zoltán , 16 January, 2019

Use this command to list all listening IPV4 ports with ip and port numbers:

$ netstat -anl -f inet
By Fekete Zoltán , 26 July, 2018

Save this script into an sh file:

#!/usr/bin/env bash

DBNAME=$1
INFILE=$2

SED_FILTER="/^-- Current Database: \`$DBNAME\`/,/^-- Current Database: /p"

sed -n "$SED_FILTER" $INFILE > $DBNAME.sql

echo "Dump is ready: $DBNAME.sql"

exit 0


Run as :

$ sh script_name dbname full_dump_file

If you want to avoid problems during foreign key imports, then insert this line into the newly generated file after the USE <DBNAME>; statement:

SET FOREIGN_KEY_CHECKS=0;