how to convert VHDX to VHD?

use Oracle VM Virtual Box

Command line, goto program folder and:

VBoxManage clonemedium disk <input VHDX> <output image>

Opensuse Version

What is the version of my Opensuse Installation?

Run command prompt / terminal and type:

$>cat /etc/os-release

NAME="openSUSE Leap"
VERSION="15.0"
ID="opensuse-leap"
ID_LIKE="suse opensuse"
VERSION_ID="15.0"
PRETTY_NAME="openSUSE Leap 15.0"
ANSI_COLOR="0;32"
CPE_NAME="cpe:/o:opensuse:leap:15.0"
BUG_REPORT_URL="https://bugs.opensuse.org"
HOME_URL="https://www.opensuse.org/"

 

How to convert FAT16/FAT32 to NTFS in Windows

c:\>convert driveletter: /fs:ntfs

a fast command to do it.

How to Flush DNS in Microsoft Windows

c:\> ipconfig /flushdns

after playing with IP config of network adapter, clients could have old IP address of destination. use ipconfig /flushdns in windows shell.

OracleException: ORA-12705: Cannot access NLS data files or invalid environment specified

Oracle Instant Client Error:

OracleException: ORA-12705: Cannot access NLS data files or invalid environment specified

Check Registry Key NLS_LANG in HKLM/Software/Oracle.

set it to valid language like GERMAN_GERMANY.WE8MSWIN1252

In some cases it helps to set above value to user environment variable NLS_LANG.

MySQL 5 – check and repair database

Shell> mysqlcheck –all-databases -p –auto-repair

Default user root, with given password.

More Information: http://dev.mysql.com/doc/refman/5.0/en/mysqlcheck.html

Example Output:

mytable
warning  : Table is marked as crashed
error    : Size of datafile is: 593178624         Should be: 593179500
error    : Corrupt

Repairing tables
mytable
info     : Found block that points outside data file at 593176692
status   : OK

Domain Group Members

How to show group members of a domain group?

in Windows Command Prompt:
NET GROUP groupname /DOMAIN

Microsoft Products – End of Life

Microsoft has a good site to check their products lifecycle support. See it here:

http://support.microsoft.com/gp/lifeselect

How to install RPM?

rpm -Uhv {name}.rpm

Parameter info:
U for Update or Install, better than option “i” as it also upgrads
v for verbose information
h for print hash marks, Install progress

f.ex.:

# rpm -Uhv oracle-instantclient11.1-basiclite-11.1.0.7.0-1.x86_64.rpm

how to upload CSV File to MySQL Database

LOAD DATA LOCAL INFILE 'c:\\usr1.csv'
INTO TABLE addressen
FIELDS TERMINATED BY ','
ENCLOSED By '"'
LINES TERMINATED BY '\r\n'

* Load Data Local Infile @ mysql.org
* File saved in UTF8 (OpenOffice 3.0)
* Mysql Query in UTF8 (advanced parameter: default-character-set=UTF8)

* Mysql 5.0 show variables:

mysql> show variables like 'char%';
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | latin1                     |
| character_set_connection | latin1                     |
| character_set_database   | latin1                     |
| character_set_filesystem | binary                     |
| character_set_results    | latin1                     |
| character_set_server     | latin1                     |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)

Comment:

23000 rows inserted in 3 seconds