MySQL or MariaDB install has default value of sql mode named STRICT_TRANS_TABLES. The MySQL docs for STRICT_TRANS_TABLES state: Strict mode controls how MySQL handles input values that are invalid or missing. A value can be invalid for several reasons. For example, it might have the wrong data type for the column, or it might be…
1. Search for virtualbox group id, make sure you already put your username under vboxusers group: $ cat /etc/group .. vboxusers:x:122:kumkum .. 2. Add this line to /etc/fstab: none /proc/bus/usb usbfs devgid=122,devmode=664 0 0 3. Reboot system. Finish. Try plug your usb device to VirtualBox. Note: – devgid=122 is vboxusers group id which is taken…
.dmg is file extension of archive file in Macintosh. To use .dmg file in Windows environment, we have to convert it into .iso file using a program called dmg2iso. dmg2iso is an Apple’s compressed dmg to standard (hfsplus) image disk file convert tool. 1. Download dmg2iso converter program from http://vu1tur.eu.org/tools/download.pl?dmg2img-1.6.2-win32.zip 2. Extract the downloaded .zip…
Using a tool called iftop we can monitor bandwidth usage via command line on Linux. But here we will create our own shell script to monitor bandwidth usage. The idea is to read rx_bytes and tx_bytes files inside /sys/class/net/[interface]/statistics/ folder. Create netspeed script in /usr/local/bin/ and copy and paste below script. Script content: Exit nano…
To scan access point: # ifconfig -M uath0 To connect to access point (dhcp): # ifconfig uath0 nwid Wireless@SG # dhclient uath0 To connect to access point (static IP): # ifconfig uath0 inet 192.168.0.2 netmask 255.255.255.0 nwid Wireless@SG
If you are tired of using ‘sudo‘ to execute command line activities, you can switch to root user (super user). First of all, we assign a root password: After assign password for root user, you can switch to root user using ‘su’ command and type in the password:
Run the following command as root or using sudo: And then select your timezone from the prompts. After that UTC time and local time will be shown as in the following example:
Rsync is awesome tool for synchronize local files or directories with files and directories on remote server. Rsync is commonly used for data backup. For rsync installation you can read this article. Below is command line how to use rsync with ssh. You will be asked for a ssh password before rsync can start synchronizing….
This is step by step how to migrate from WordPress to Blogspot: 1. Login to WordPress and go to Dashboard => Tools => Export => press Download Export File button. 2. Go to http://wordpress2blogger.appspot.com/ and submit the .xml file exported from WordPress, then you will have another .xml file downloaded. 3. Login to Blogspot and…