rsyslog loses some messages
You write your good program to use the rsyslogd installed on your system. You would have a bunch of log lines, but you can't see any. Check this:
Fekete Zoltán Tue, 12/04/2018 - 07:35

Tags

Extract one database from mysql/mariadb full dump

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;
Fekete Zoltán Thu, 07/26/2018 - 13:51

Tags

Start LXDE on NetBSD
After installing LXDE either from binary or from pkgsrc, it wouldn't start. Here is how to solve:
Fekete Zoltán Wed, 04/18/2018 - 14:25

Tags

Sync master zone file with bind9 journal

This command synchronizes all current setting with zone file, and also removes the journal (jnl) file:

# rndc sync -clean

 

Fekete Zoltán Fri, 01/05/2018 - 15:21

Tags

List foreign keys of a referenced table in mysql or mariadb 
mysql> select constraint_name, table_name
       from information_schema.key_column_usage
       where referenced_table_name = '<TABLE_NAME>';
Fekete Zoltán Mon, 12/18/2017 - 10:17

Tags

Subscribe to