AWSurveys is a Scam ?

Read this.

So it's better to think twice if you put already awsurverys banner on your website or blog.

I decided to remove that banner from my blogspot.

Tutorial Auto Backup Database on Linux Server

Yesterday I and my wife went to RSUD Karanganyar to install and create auto backup database on Linux server.
I use Mandriva 2008 as an OS because it's easy to install.

After success installation, I created script to crontab every hour.
Here is my script, of course it's not my own script.

Ok, coffee and smoking mode on

Once again, this is not my own script, I modified from here.


1. Type this command in shell :

bash$ echo your_host:5432:your_user:your_db:your_pass > ~/.pgpass
bash$ chmod 600 ~/.pgpass


2. Create backup.sh in directory /backup and name it as backup.sh :

#!/bin/sh
/usr/bin/pg_dump -D -U qwe simrs --no-owner > /backup/simrs.sql
cd /
cd /backup
tar --overwrite --remove-files -czf /backup/simrs-`date '+%Y-%m-%d'`.tar.gz -R *.sql
chmod ugo+r -R *
cp -f *.* /var/www/html/backup
cp -f *.* /mnt/win_d/backup


3. Edit /etc/crontab and add bold line in crontab file :

SHELL=/bin/bash

PATH=/sbin:/bin:/usr/sbin:/usr/bin
MAILTO=root
HOME=/
# run-parts
01 * * * * root nice -n 19 run-parts --report /etc/cron.hourly
01 * * * * root /backup/backup.sh #<-- add this line
02 4 * * * root nice -n 19 run-parts --report /etc/cron.daily
22 4 * * 0 root nice -n 19 run-parts --report /etc/cron.weekly
42 4 1 * * root nice -n 19 run-parts --report /etc/cron.monthly


4. run crontab as root

root@server:~# crontab -u root /etc/crontab


5. check one hour later, or just type :

root@server:~# crontab


After I check /backup directory there is new file simrs-data.tar.gz
I check again at /var/www/html/backup directory, there is also new file simrs-date.tar.gz
I double check again at /mnt/win_d/backup directory, well... it's succeeded

Thanks to open source community :)

Should I Give Up on Google Adsense ?

My friend said to me that Google AdSense supports Indonesian language, but after read his email, I found this link.

Now I know why another friend of mine warn me when I used Indonesian language as content of this blog.

Talking about Google Adsense, I -almost- lost my hope to earn some buck from it.
It's -almost- impossible to make my reader click on Google Adsense banner, as I don't do it while I surf to another blog.

So if you have a good experience how to earn money from Google Adsense, please share it with me

Thank you...

===================================================================

Google AdSense supports publishers in several different languages. Applications for participation in the program can be for sites with content primarily in:

Arabic	Hungarian
Bulgarian	Italian
Chinese (simplified)	Japanese
Chinese (traditional)	Korean
Croatian	Norwegian
Czech	Polish
Danish	Portuguese
Dutch	Romanian
English	Russian
Finnish	Serbian
French	Slovak
German	Spanish
Greek	Swedish
Hebrew	Turkish

In addition, AdSense for search is available in Indonesian, Thai, and Vietnamese. These languages are not supported for AdSense for content pages.

You can select your site's primary language during the application process. If you're approved, AdSense will serve relevant ads to your pages in the appropriate language, even if your site contains multiple supported languages.

Please also be aware that placing the AdSense code on pages with content primarily in an unsupported language is not permitted by the AdSense program policies.

New Blogspot : HotBookmark

I decided to create one more blog to collect my bookmark, instead using create-export-import bookmark from Mozilla Firefox bookmark facility.

So if my operating system crash or have a BSoD, my bookmark still safe in that blog

I also create that blog to share my bookmark for you :)

Finally this is that blog ... http://hotbookmark.blogspot.com

Start to collecting ...

Tutorial Create Alexa Widget

- Kangkam -

How can we know how many people visit our website or blog ?
How many people links to our website or blog ?

Yes, that question crossed in my mind when I was thinking about Google AdSense.
So I googling around to find any widget that can count how many people who visit my blog.

With keyword "site rating" I found Alexa in top of my search.
And here we go the tutorial to put Alexa on blogspot.

Ok, let's start ...

Choose option Widgets








Choose what your desire type will show to your blog / website.

Fill the input form as requested




Choose what is your desire to show up to your blog
There is 3 options :
1. Traffic Graph Stat
2. Site Stats
3. Traffic Rank

I choose the last one, because it's simple and fit on my blog space.






After you klik build widget you have another three options script that you can copy paste to your blog.
















If you have classic template for your blog, you should now how to add that script to your template :D

- Kangkam -