My website statistics are showing zero values

My website statistics are showing zero values

You may not see any visitors in your statistics for the following reasons: Your domain is not pointed to our server. In order to fix this please check the following article. Your statistics have not been updated. In order to fix … Continued
My subdomain statistics are not up to date or they do not appear

My subdomain statistics are not up to date or they do not appear

The users’ web statistics on XonHost servers are updated every night. This update may be delayed by high server load or software problems. If your subdomain statistics have not been updated for more than 24 hours you can manually update … Continued
How to enable the manual statistics update within Awstats

How to enable the manual statistics update within Awstats

In order to enable the manual statistics update in Awstats, you should edit the following file: tmp/awstats/awstats.yourdomain.com.conf (substitute yourdomain.com with your domain) Look for the following line: AllowToUpdateStatsFromBrowser=0 and change it to: AllowToUpdateStatsFromBrowser=1 This option is enabled by default on hosting accounts on … Continued
My website Stats are not updated

My website Stats are not updated

The users’ web statistics on XonHost servers are updated every night. This update may be delayed by high server load or software problems. If your statistics have not been updated for more than 24 hours you can manually update them … Continued
What are MySQL triggers and how to use them?

What are MySQL triggers and how to use them?

The MySQL trigger is a database object that is associated with a table. It will be activated when a defined action is executed for the table. The trigger can be executed when you run one of the following MySQL statements … Continued
MySQL optimization using indexes

MySQL optimization using indexes

A database index is a data structure that improves the speed of operations in a table. Every time your web application runs a database query, the database will look through all the rows in your table to find those that … Continued
How to reduce the size of a MySQL database

How to reduce the size of a MySQL database

MySQL database size limitations are applied for all shared hosting plans, in order to ensure fair resource usage. The limitations are as follows: StartUp – 500 MB GrowBig – 750 MB GoGeek – 1000 MB If a database on your … Continued
What is my MySQL Server Hostname?

What is my MySQL Server Hostname?

If you want to connect to your database from an application or a script on your XonHost hosting account, you can simply use localhost as MySQL hostname. If you’re accessing your database from a remote server, you need to grant it access … Continued
How to Export MySQL Database

How to Export MySQL Database

There are two ways of exporting a MySQL database from your account: You can export it via the cPanel -> phpMyAdmin tool. You can find information how to do that in our tutorial here. You can perform the export by accessing your account via SSH. Our article explains … Continued
How to change the password of a MySQL user in cPanel?

How to change the password of a MySQL user in cPanel?

The easiest way to change the password for your MySQL user is to: Log in your cPanel -> MySQL Databases. Find the corresponding database and see which is the user attached to it. For example we will consider that your database is called yourusername_database and … Continued