Rice Blogger

I have always believe in website uptime affecting our SEO ranking and reduces the return visitor. This is one of the very important criteria when you pick a webhosting and not the price. I am using this service from AreMySitesUp, as poor as many of you out there, I am using the free service with 5 domain name. This is fine with me, the only downside for the free account is that this website will delete inactive users, because I do not need to check the website for my status, I tend not to login to the website.

Anyhow, I think it is a nice service to share. Let me know if you use other service for monitoring your website uptime.

Site: http://aremysitesup.com

Other than files, you need to also move your database. If you are use to the GUI, you know that there is limitation exporting and importing. This is especially true when you have a large database. Through phpmyadmin, it is also a lot slower compare to method whereby you export large MySQL via SSH.

The command:-

mysqldump -u [username] -p [DB name] | gzip > [dbname].sql.gz

It will prompt for password, type in the password for this access to the database. You will get a file name exactly like what you have typed at the end of above command ([dbname].sql.gz).

Use an ftp program to download the file.

Because the file is compress, you are downloading it even faster, and you can un-compress it on your new webhosting.

To Import the large MySQL

gzip [dbname].sql.gz

then

mysql -u [username] -p [DB name] < [dbname].sql

** If you uses a different username and DB name in your new webhost, use the new value in the bracket

I hope this this will actually make moving your wordpress or your website to another webhosting much easier.

This trick actually works well with most php scripts. There is lots of benefit to this rather than ftp out the file from your old host then ftp back all the files to new host. The better I would suggest is to zip your folder for the particular domain whereby you can use the following command:-

tar -zcvf zipfilename.tar.gz foldername/

ie. You moving a domain at riceblogger.com/. use command: tar -zcvf riceblogger.tar.gz riceblogger.com/

then move the zip file to your new host via ftp. To extract .tar.gz, you use this command

tar -zxvf riceblogger.tar.gz

I had no other choice to expore these command because I have a classifieds that contain few thousands of picture in a folder, with Filezilla, I could only display 2000, and I kept missing pictures. With zipping, I can download and upload much faster.

There is also ways to extract large MySQL via SSH. I will post them later. Since I start learning more SSH for my 9 to 6 job, I found it so useful, and it also helps in my experience as a webmaster/blogger/internet marketer. Not to forget my previous post Upgrading Wordpress via SSH, it is still useful when we want to install a new blog, or the automatic upgrade is not working.

An important task as a webmaster is to prevent your resources to be stolen or your website to be hacked. I had both of this experience now after finding one of my blog got 280gb of bandwidth used on the month of June 2009 and even at 2rd week of July it is already at 350+gb of bandwidth used. Fortunately and unfortunately, I did not even get any warning email and no service disconnection from my Hostgator Shared Hosting account.

This is the stats with around 1k users a day. You can confirm someone is stealing your bandwidth when you see a sudden of increase in bandwidth usage and also see that your image bandwidth is taking a whole chunk of your bandwidth (my case was 96% of the 400+ gb at the end of the month)

Immediatelly I use .htaccess to prevent image hotlinking by adding the code below into the .htaccess file:-

RewriteEngine On
RewriteCond %{HTTP_REFERER} !^http://(.+\.)?website\.com/ [NC]
RewriteCond %{HTTP_REFERER} !^$
RewriteRule .*\.(jpe?g|gif|bmp|png|jpg)$ /no-hotlinking-image.jpe [L]

I know that there is draw back on this but this is the quickest and most popular method to solve this problem and as you see the bandwidth drop pretty quickly after 13 July. After that I have reduce the size of  my no-hotlinking-image.jpe to a bare minimal and also remember to include some advertisements on the image.

To find out who is stealing your image bandwidth you can check out the raw access logs. This is where I look for at cpanel admin. Download the logs and if you see some image being load on other url other than yours, visit them and you should see your image (no-hotlinking-image.jpe) display on their page.

Recently I bought myself a Nikon D90 Kit, and this is my new hobby when I am not in front of my computer. To publish my amateur photography, I have decided to use my change my personal blog into a Photoblog. I have did some research for free Wordpress Theme for Photographer and found this five great theme.

Grace Photoblog Theme (Demo : Download)

This is a simple designed photographer theme that have a 900px rotating picture in front. Very nice size and method to present your photos.

Monotone (Demo : Download)

This theme changes width accordingly to your picture width and it also changes the background color to give a different look for each visitors.

Fullscreen (Demo : Download)

This is simply cool. Mouse over the picture and you will get what I mean. It is not Free yet, but they claimed that it will be given away free soon, so signup and wait.

Reflection (Demo : Download)

Create a reflection on all your photos with the help of YABP photoblog software.

Photo Blog Wordpress Theme (Demo : Download)

It gives you picture a great deal of focus, mouse over the picture and you see the description. Also click on the blog info to get the archive, blogroll, pages and category.

Bonus: Zack 990 (Demo : Download) – Found it last minute

This gives your pictures collection a very organize way to browse. Few method of displaying pictures as you can see from the screenshot below.

If you are a photographer and would like some wordpress theme that would enhance your picture layout, this is definitely for you. This theme are also suitable for videographer blog. The best thing is that they are free.