Information Technology

  How to create sitemap .xml using the GSiteCrawler

Honestly, i have been looking for the perfect tool / site to generate a sitemap (.xml) without any limitation such as the numbers of pages generated. I did come across plenty of free sitemap generators through google, nevertheless i can't find any that's not being limited to a certain number of pages. After days of searching, i have finally found an application software designed for sitemap generator, which means you have to first install it locally. Once you installed GSiteCrawler  you will be able to run it without any limitation and extra optional features not to be offered by any other sites out there.

Go visit the GSiteCrawler site at the following link: http://gsitecrawler.com/, download the software and install it. on your PC Once, you have successfully done that, double click the software to run it as usual.

1. The following screen is the initial page that you will normally encountered once you execute the software.

 

2. Click on "Add new project" once you are ready to generate a sitemap with your website. Ensure you have to include the http:// (or https://) prefix and ends with a trailing slash (/).




  Migrating web hosting email to gmail using Google apps

Honestly, i'm a fan of google mail (gmail). I'm more comfortable and accustomed using it rather than any email hosting, or even web hosting email. Additionally, to use a web hosting email, you have to first login to your web hosting account, then access the email application.

It's a 2 or 3 clicks compared to gmail account, plus you are opened up a possibility of exposing your web hosting account (username and/or password), if you are accessing it in public computer (internet cafe). How about if you can access your email conveniently, only 1 click away and URL friendly such as http://mail.yourdomainname.com ? Marvelous, ain't it.

1.

First of all, you have to setup your Google aps standard edition using your domain name (for ex: eangkasa.com) by going here http://www.google.com/a/cpanel/domain/new




  Increase your website ranking through Google, Yahoo and Bing

After a website is finalized and ready to be launced worldwide, the next crucial step will be to promote the site on the Internet and achieve a decent traffic. The most obvious way is to increase your site ranking in prominent search engines such as Google, Yahoo and Bing. By having a top ranking in these 3 search engines will eventually boost your site popularity, attract more customers and thus, increase your site traffic.

The following approaches will deliberately explain on how to increase your site ranking:

1. Verify your site ownership and submit your sitemap through Google, Yahoo, and Bing webmaster.




  Import large MySQL database (phpMyAdmin limitation)

I have encountered this issue about a week ago, when i'm exporting my database through phpMyAdmin tool, the export works very well and the output file is up to 10 MB in size. The main issue comes when i would like to import it back using phpMyAdmin, but guess what happened, a timeout occured.

 

I will kindly break it down for you, there are 2 limitations surrounding phpMyAdmin from importing a very large MySQL database:

1. A time out is divided into a server timeout and browser timeout. This basically means when a script is being executed for too long that it has eventually passed the time limit either on the server and/or browser, the script will cease to run. Simply put, the larger your file is, the longer it takes to be executed, the bigger chance it fails.

You could actually bypass the browser timeout by modifying the about:config setting if you are on Firefox, unfortunately for server timeout, if you are on shared hosting like me, you are unlikely to get access to modify the server config.

2. File size limit on certain web hosting companies. Normally, i would say a 10 MB filesize limit is being implemented by most web hosting companies, if your MySQL filesize is more than that, then you're out of luck. Fortunately, my hosting company (BlueHost) is generous by allowing me to upload up to 50 MB filesize.