The MySQL Activity Report package is a tool to help MySQL database administrators to collect several database parameters and variables. These collected values can be used for server monitoring or performance tuning purposes.

The most important component of the MySQL Activity Report is mysqlard. This daemon collects the data from a MySQL server and stores these values in a Round Robin Database.

The mysqlard package also contains example graphing, cron and php scripts. The cron scripts can be used to keep archives of the generated graphics and the php script shows the generated graphics and tries to give some tuning tips.
Continue Reading »
Howto MySQL Activity Report

This auto mysql backup script will dumps all sql databases into a remote or local ftp server.
Continue Reading »
Howto Auto MySQL Backup on Ensim

Backing Up & Restoring a MySQL Database using phpMyAdmin / SSH

This is just a short mini-tutorial explaining how to backup parts of the mySQL database using phpMyAdmin & also via SSH (Secure Shell) access. This tutorial should be of use to most people, as it’s an important part of any website/forum maintenance!

So, let’s get started…
Continue Reading »
Howto Backup/Restore Using phpMyAdmin/SSH

WARNING:
RavenCore is designed to be installed on fresh systems. If your server already has a different control panel, or was configured manually to host domains, RavenCore WILL NOT detect them, and you will have lots of problems with those settings no longer being in place.
Continue Reading »
Howto Install RavenCore

Important Post Installation Step
Make sure that you open the ports 7778 and 7777 in the firewall. Otherwise you won’t be able to connect to lxadmin.
Continue Reading »
Howto Install LxAdmin

First, make sure you have install PostgreSQL on your DirectAdmin, or you can install it using this howto.

Lets start…
Continue Reading »
Howto Install phpPgAdmin on DirectAdmin

This how to will guide you on installing PostgreSQL 8.1.5 on DirectAdmin
There are two ways to install it:
Continue Reading »
Howto Install PostgreSQL on DirectAdmin