[Andhy] Zero Zone

My new Gadget : HP Mini Note 2140

Finally I bought ultra-light notebook or commonly known as mini notebook HP Mini Note 2140 with 6 cell battery and 10.1 inch screen at Device Vaganza, an event which was hold by my Company four days ago. At that event, I was given extra discount by the seller for buying that mini notebook so I just need to pay at price USD 450 with exchange rate at that time was 1 USD = 10,400 IDR while the normal price in the market is USD 585. That means I save USD 135 for this case.
The packets which were received along with mini notebook were soft case bag and another big bag from HP.

My mini notebook is powered by Intel® Atom™ Processor N270 (1.6 GHz, FSB 533, Cache 512 KB) with memory 1GB DDR2 SDRAM 667MHz. The maximum memory for this mini notebook is actually 2 GB but when I asked the seller if I want to add the additional memory, they said that I should go directly to their office as they do not bring the additional memory, so I decided to cancel for this one.
The storage for this notebook is 160 GB Hitachi Hard disk 5400 RPM SATA with Drive Guard Technology (HP’s 3D DriveGuard accelerometer) which able to loc the ring of the hard disk when there is any vibration. The graphic card is powered by Intel® Graphics Media Accelerator 950 DVMT 64 MB which shared from memory. For Connectivity, this notebook have WIFI Broadcom 802.11 a/b/g which can support the data rate up to 300Mbps, Gigabit Ethernet, and also have Bluetooth wireless technology .

This HP Mini Note has surface covered by professional-looking aluminum and magnesium-alloy that make this mini notebook different with the other mini notebook. The screen size is 10.1 inch with resolution 1024×576. At the up of the screen, we can find VGA webcam as built in. This notebook also have nearly full sized keyboard with nearly similar to standard Notebook (92% of standard keyboard). The touch pad buttons is on the left and right instead of underneath and the touch pad can be deactivated or activated by on/off button. At front side of this mini notebook, we can find power button, drive light, and wireless button. On the left side we can find USB port, vent, and audio in/out jack while in the right side we can find Express Card Slot, SD card reader, USB port, LAN Port (RJ45), power connector, battery light, and also loc slot.

HP Mini Note 2140 which I bought is using Windows XP Home as Operating System with 60 days trial of MS Office 2007 and trial of antivirus Mc Afee Total Protection for 30 days. With six cell battery, this mini notebook can be used without recharge for approximately 5 hours. At first time, the 160 GB SATA Hard disk is not being partitioned so there is whole 160 GB as Drive C. When I tried to make partition, I could not get the result as I expected. :sad: I don’t know why this 160 GB cannot be partitioned using standard method of partitioning windows XP. Then, I tried to use Partition Magic but I still cannot make partition. After that, my Friend suggest me to use EPM (Easeus Partition Master), a free partition software which look similar with partition Magic. By this software, finally I successfully make partition on my 160GB Hard disk into two partition, 25 GB as Drive C and 124 GB other as Drive D.
For further information on benchmark of this HP mini note 2140 with other mini notebook, you can browse in laptopmag.com.

Share and Enjoy at:

3 July 2009 || Gadget, Joke, Technology || Add Comment

My Blog goes Mobile Version

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

Share and Enjoy at:

27 June 2009 || Application, Gadget, Technology || 7 Comments

Load MySQL Database from Spreadsheet using Shell Script

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.

Share and Enjoy at:

27 June 2009 || Learn || Add Comment

Backup MySQL Database Regularly using Shell Script

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

Share and Enjoy at:

27 June 2009 || Learn || 1 Comment

Grojogan Sewu : Wisata Air Terjun di Tawangmangu

Tawangmangu adalah sebuah kecamatan di sekitar lereng Gunung Lawu, Kabupaten Karanganyar, Jawa Tengah. Tempat tersebut kira-kira berjarak 1.5 jam perjalanan (50 Km) di sebelah Timur Kota Solo. Di Tawangmangu tersebut sebenarnya banyak dijumpai tempat wisata antara lain candi sukuh, candi cetho, air terjun jumog, dll, namun yang paling banyak dikunjungi dan paling popular adalah Air Terjun Grojogan Sewu. Air Terjun Grojogan Sewu terletak di sebuah hutan wisata yang masih asri dan alami. Meski cuma berjarak sekitar 1.5 an jam dari rumahku, namun aku baru 2 kali ke sana. Satu saat masih Taman Kanak-kanak alias TK, dan satu lagi kemarin hari Sabtu, 6 Juni 2009. Kami ke sana naik bus umum tujuan terminal Tawangmangu. Sekedar informasi, bus umum yang tujuan ke sana setiap hari sekitar 40 kali frekuensinya dan ternyata tidak ada yang menggunakan AC. Namun tenang saja, udara di daerah sana sejuk dan dingin sehingga tidak perlu AC lagi. Jalan menuju terminal Tawangmangu sangat banyak kelokan tajam dan curam dengan disamping kanan-kiri jalan tersebut banyak yang berupa jurang dan atau areal persawahan yang terlihat hijau dan subur. Setelah sekitar 1.5 jam perjalanan akhirnya kami sampai di Terminal Tawangmangu. Terminal ini sudah banyak perubahannya, terminal yang dulu semrawut sekarang sudah lebih tertata dan tidak terlalu menimbulkan kemacetan lagi. Juga pasar tradisional yang ada di depan pasar ternyata sudah menjadi pasar yang semi modern dan lebih tertata teratur juga. Dari Terminal Tawangmangu ini, kami melanjutkan dengan naik angkot untuk menuju Air Terjun Grojogan Sewu. Jarak objek wisata Air Terjun Grojogan Sewu cuma sekitar 800an meter dari Terminal Tawangmang. Jarak pintu loket dengan jalan raya utama sekitar 200an meter dan tidak ada petunjuk jalan atau plang pengumuman di jalan raya yang memberi tahu bahwa belokan jalan itu adalah belokan jalan menuju Objek Wisata. Hm..
Read More …