The following tutorial can be used as dictionary for beginner on SQL syntax. SQL syntaxes are used to manipulate data which are select, insert, update, and delete on database. 1. Select Select command is used to get rows of data from table. Syntax: Example: 2. Insert Insert command is used to insert row to table….
Prepare at least 3 partitions: – Partition 1, 80GB, for Windows 7 – Partition 2, 80GB, for Mac OSX – Partition 3, the rest, for Data 1. Install Windows 7 on partition 1 2. Install Mac OSX on partition 2 For Mac OSX, I was using AsereBLN boot loader. To switch between Mac OSX and…
CableNut is a tool for optimizing your Internet Connection. We have provided a way to tweak any option you may want to in the adjuster. You can load “CableNut Custom Setting” files that are included with the program to tweak your Internet connection. You can make your own “CableNut Custom Setting” files save them for…
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:
SingTel APN: e-ideas Username: 65ideas Password: 65ideas APN: internet Username: LEAVE_BLANK Password: LEAVE_BLANK Starhub APN: shwap Username: LEAVE_BLANK Password: LEAVE_BLANK Proxy: 10.12.1.2 Port: 8080 M1 APN: sunsurf Username: 65 Password: user123 APN: miworld Username: 65 Password: user123
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…
First of all, install these packages: apache2, php5, subversion. # apt-get install apache2 # apt-get install libapache2-mod-php5 # apt-get install subversion # apt-get install libapache2-svn Create repository folder. # mkdir /subversion # svnadmin create –fs-type fsfs /subversion/kendal Make sure subversion is activated in apache. # a2enmod dav # a2enmod dav_svn Create user account for subversion….