;       Small Business Web Hosting Blog dedicated to provide useful and quality information on Web Hosting Solution

If you are planning to use MySQL on Windows small business web hosting server there wont be any issues and you can use it easy, all you have to do is to install MySQL by following download instructions provided at mysql.com you just have to dump collection of and directories into the c:\mysql directory. You can visit c:\mysql\bin and list the .exe files to see what is available.

You can use following commands for more details :

c:\mysql\bin>mysqld-nt –install
c:\mysql\bin>mysql

Once you run the above commands, you will have command line prompt where you can enter all your SQL statements.  If you need to exit from prompt you need to fire ‘exit’ command.

MySQL always run in the background which never gets stopped, even resum itself even  after rebooting Windows.

You have ‘net’ command using which you can control windows services, to get list of all services currently installed you just need to use

c:\mysql\bin>net start

You can see MySQL as one of the running services and even if you reboot NT this service will be continued. If you want to stop the service you can do so easily using following command.

c:\mysql\bin>net stop MySql
c:\mysql\bin>mysql-nt –remove

once MySQL is stopped you may want to start it again with different version of MySQL like mysql-max-nt, in this case you will use following command

c:\mysql\bin>mysql-max-nt –install
c:\mysql\bin>net start MySql

Thus, you can use MySQL efficiently even on windows NT and can start/stop it easily using few commands. You can also manage email hosting services through Windows Plesk hosting packages.

Posted under email hosting

Today almost all web hosting providers provide cPanel as control panel with their Linux web hosting plans. cPanel is bundled with many useful features which are pretty much important for any webmaster for getting all the details about their website.

cPanel contains different web statistic programs which are very useful for analysis of the website such as AwStats, Webalizer and then a built in bandwidth usage chart.

All programs have sole aim and provide statics and charts to inform you about bandwidth and other traffic stats of your site.  Each Program works differently but have only goal to provide the traffic details.

AWStats :

AwStats is one of the built in add-on which comes with cPanel. This addon need to be activated using WHM for your cPanel account so that you can use it with your account.

This add-on is very useful for getting all info about your visitors, such as number of daily visitors, their source, what pages they visited, for which search query they are pulled and much more. All this information can be very useful for deciding your level of success and on what you need to concentrate more.

AwStats provides you detailed information for all your visitors such as their hostname, from which country they came, thus you can get summery report for traffic.

AwStats also help you in SEO as it captures search keywords/phrases that are used by your visitors while getting into your site from Search engines. You can also get info about your OS, Browser your visitors are using. This info can be very useful while optimizing your site for SE’s, also you can break down your visitors history into monthly history, weekly history, daily history as well as hourly history which can help you for crosschecking your sites popularity and traffic.

Posted under Web Hosting