Paguyuban Blog EL2003 ITB

Bali, 17 Juli 2008 Posted in Obsesi : Keliling Indonesia

Bengkulu, 26 Juni 2009 Posted in Obsesi : Keliling Indonesia

Cepet jadi yah……………………. Bogor, 10 November 2008 Posted in HVDC

Palembang, 26 Juni 2009 Posted in HVDC

Lolos dari satu lubang jarum. Bener-bener seneng banget kemaren (sekarang sih udah biasa aja..). Mengucapkan terima kasih atas dukungannya. Terutama dukungan teknis (makasih ya tiko, kachu..), dan dukungan moral dari orang2 terdekat Semoga suatu saat hasilnya bisa digunakan untuk membangun bangsa (dan mencari tambahan proyek? :p) Hehehe, mulai ngarep. Aminn… Euforianya sampai di sini saja. (Harus) siap untuk switching [...]

Kisah ini kudapatkan dari lingkaran cahayaku tiap pekan. Tentang seorang anak “malaikat” yang luar biasa. Murabbiku mulai bercerita dengan gayanya yang khas. Tentang anak sepasang aktivis da’wah. Alkisah sang Umi dan Abi mendidik anaknya begitu baik, dalam bi’ah yang teramat kondusif. Waktu-waktu sang mujahid kecil lebih banyak dimanfaatkan untuk hal-hal yang bermanfaat di dalam rumah, berinteraksi [...]

impian hari ini dan kenyataan hari esok akan selalu memiliki IRISAN. Akan ada kesamaan-kesamaan dari apa yang kita impikan hari ini dengan kenyataan esok hari. Karena itulah adanya sebuah tuntutan untuk tetap memiliki MIMPI BESAR yang dibarengi dengan KERJA BESAR. Tapi tetap semuanya berawal dari apa yang ingin kita capai. Sebuah visi. Sebuah tujuan akhir [...]

The effect of booming in smart cellular phone like Iphone & Blackberry and the decreasing of data charging by cellular operators, have caused the increase rapidly in mobile web activity. Therefore in order to accommodate mobile web activity, there are many blogger provide a mobile version of their blog. This mobile version is aimed to make browsing the Web from mobile devices comfort and fast by scaled down the theme and content of blog suitable with the screen of the device.

Actually, I realized that I should add mobile version of my blog when I browsed my blog via my cellular phone. At that time, I could not do fast browse due to long time response of loading. And then, after the page was loaded perfectly, the page which used blueweed theme was very not suitable with small screen device so I need to scroll left and right in order to read completely. 

I know that careful steps need to be taken when optimizing a website to be mobile friendly especially in accessibility. Then I start searching the wordpress plugin which able to create mobile version of my blog which have user friendly structure, simple graphic or have no graphic, and have simple theme which can be easily modified.

After further searching, finally I find wordpress plugin which support mobile version called wordpress mobile pack.

This plugin includes a mobile switcher which able to select themes based on the type of visitor who is visiting the site. If the visitor comes from Computer browser, the mobile switcher will switch the theme into original theme which is blueweed theme, while if the visitor comes from mobile cellular phone browser the mobile switcher will switch the theme into mobile version. This plugin also have the ability to select mobile themes  so I can easily modify the original mobile theme. The other important feature is called device adaptation. By this feature, this plugin has basic recognition of mobile devices and is capable of rescaling images, splitting articles and posts in multiple pages, simplifying style and remove media so the mobile version will be fit in cellular browser.
Below is my score for this blog in mobile version based on ready.mobi

So in my opinion, this plugin is worth to be tried

Point your mobile browser to http://andhy.qwords.net to see my blog in mobile version

Seberapa banyak sms menumpuk di inbox hp? Seinget gw sih, di salah satu hp, gw pernah 5000, mungkin malah 7500an lebih.. Tapi ternyata si hp imut gw ini kurang mampu menampung lebih dari 2000 sms saja.. Gejalanya jelas.. Performa handphone menurun.. Kecepatan akses menu-menu di hp melamban.. Tapi emang dasar udah sifat dasar gw yang sabar, selama ini gw diemin aja.. (penghalusan [...]

Barbeque di tepi pantai.. Idenya boleh juga, tapiii… ternyata pelaksanaannya tidak semudah yang dibayangkan. Bapak nelayan yang mengantar kami ke pulau Badul memberi 5 ekor ikan secara cuma-cuma (makasih Pak Nelayan..). Bayangan kami sih, enak banget ikan2 ini dipanggang malem2. Ternyata, waktu ditinggal mandi, ikan yang ditaro di saung itu berkurang jadi tinggal 4 ekor. Lhaa…. Siapa yang ngambil *_* (yang [...]

When we have a spreadsheet file with huge content which should be loaded into MySQL database, then what will we do?
For me, i prefer use shell script. So, how?

Well, before we do it, we need to understand the format of the spreadsheet first. The spreadsheet file consists of rows and columns, so what we need is to find how to identify each row and column. I don’t know how to identify rows and columns in shell script, therefore, in order to load the data correctly, I export the spreadsheet into plain text file by copy the entire content of the spreadsheet file and then paste it into plain text file.
If we copy a spreadsheet excel file and paste it into text file, each column in excel will be identified by tab and row will be identified by line in text file. From this, we can use symbol \t for tab and symbol \n for new line.
Before attempting to convert any spreadsheet into text file, it is best to review the data for consistency. For example, make sure that every row has the same number of columns and check that all dates are formatted in the same way.
After that, we can use shell script to load the plain text file into MySQL database using command LOAD DATA LOCAL INFILE.
The term of LOCAL is used because my MySQL server is remote server. That means my MySQL server is located in different server. See my previous post to know my server configuration.

Here is my simple script :

#! /bin/sh
# filename : updatedb.sh
# Load data from file into MySQL
mysql -u USER -pPASSWORD -D mydatabase -h 10.1.1.10 -e
"LOAD DATA LOCAL INFILE 'mydata' INTO TABLE mytable
FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n';"

By that script my file is successfully loaded into MySQL database.

Sometime, we need to backup our database regularly in order to avoid something bad ( paranoid mode)
Bellow is the simple shell sh script for backing up MySQL database by dumped the database and then put it into gzip file with the date of backup as the name file.

Here is the condition of my server :

• My MySQL server is located in IP Address 10.1.1.10 with username = USER and password = PASSWORD
• The name of database which should be dumped regularly is mydatabase
• My backup server is located in IP 10.1.1.15
• The path of mysqldump in my backup server is located in /apps/local/mysql/bin/mysqldump
• I want to put the gzip backup files in folder /backup/BACKUPDB in my backup server
• My backup script is located in /script folder in my backup server

Here is the simple script :

#! /bin/sh
# filename : backupdb.sh
# Automated database datestamp backup
/apps/local/mysql/bin/mysqldump --opt -Q -h 10.1.1.10 -u USER
-pPASSWORD mydatabase > /backup/BACKUPDB/`date +"%d-%m-%y"`.sql
gzip /backup/BACKUPDB/`date +"%d-%m-%y"`.sql

Then, in order to run automatically that script at specific time, we need to set up cron job by adding the crontab list in backup server.
Here is example crontab for running backupdb.sh every day at 2 am.

0 2 * * * /script/backupdb.sh

Before add the script into cron job, it will be better if you check whether that script is running well or not. Do it at your own risk

Okay, kali ini gw mo cerita tentang pengalaman gw ngajar orang tentang networking.
Pertama sih deg2an. Mikir, kira2 bisa gak nih gw perform ya. Jangan2 ntar kalo ditanya gw gak bisa jawab lagi. Hilang d muka. Apalagi kalo jawabannya salah. Wah, kacau..
Tapi gw pikir2 lagi, kalo gak dicoba sayang juga sih. Ada kesempatan untu nyobain sesuatu yang baru tapi gak gw ambil. Akhirnya, singkat kata, gw jadi ngajar.
bahan yang diajar sebenernya sederhana sih. Cuma basic networking sama cisco hardware fundamental. Tapi setelah ngasih training, ternyata dibalik bahan yang sederhana tersebut masih ada juga sesuatu yang bisa digali. Dan wacananya datang dari para peserta yang belum terlalu ngerti tentang bahan yang ditrainingin.
Intinya, ternyata gw baaru merasakan sendiri bahwa ngajar itu bisa membuat kita menyadarari bahwa ada beberapa hal yang sudah jadi kebiasaan tapi kita gak tau apa yang terjadi sebenarnya dibalik semua kebiasaan itu.
Pelajaran kedua, nambah ilmu gak hanya bisa dilakukan dengan sering kontak dengan paa savvy aja. dengan para dummy juga bisa, karena si dummy ini sering dengan polosnya nanya sesuatu yang gak kepikiran sama kita. Hehehe, atau emang gw aja yang suka gak mikirin yaa. Well, who knows. Tapi yang pasti ngasih ilmu yang berguna termasuk suatu kegiatan yang mulia. So, try to teach if you have chance…