How to Optimize a MySQL Database in cPanel

Related documents:
1. How to Create a Database and User for MySQL in cPanel
2. How to Add Databases and Users Using MySQL Wizard in cPanel
3. How to Allow Remote Access to a MySQL Database in cPanel
4. How to Change the Password of a MySQL User in the cPanel

This article will give you a step by step guide on how to optimize a MySQL database’s tables in the cPanel.

Sign into your cPanel and follow these steps:

1) Scroll down to Databases and click phpMyAdmin Learn More

Tags: , , , , , , | Posted under cPanel/Linux Hosting, MySQL, Video | 6 Comments

Basic include() example

Related documents:

  1. http://php.net/manual/en/function.include.php
  2. http://forum.arvixe.com/smf/general/php-script-errors/

vars.php:

<?php
$color = ‘green’;
$fruit = ‘apple’;
?>

index.php:

<?php
define(‘BASE_PATH’,’c:/hostingspaces/shai/shai-arvixe.com/wwwroot/’);
include BASE_PATH . ‘inc/vars.php’;
echo “A $color $fruit”; // A green apple
?>

Result and expected output:

A green apple

Tags: , , , , | Posted under DotNet/Windows Hosting | Leave a comment

How to Enable Manual Statistics Updates Within Awstats

This article will give you a step by step guide on how to enable manual statistics updates within Awstats in the cPanel. When manual statistic updates are enabled, AWStats adds a button to the report page to allow the user to “update” statistics from a web browser. Sign into your cPanel and follow these steps:

1) Click File Manager Learn More

Tags: , , , , , , , | Posted under AWStats, cPanel/Linux Hosting | 1 Comment