Custom Apache and PHP modules add features to the EasyApache system, and are accessible from both the command line and graphical WHM interfaces. These modules are compiled into Apache and/or PHP just like the modules provided with EasyApache. Before you begin You can find documentation for creating custom modules your server at WHM > EasyApache [...]
How can I find all the file descriptors used by a process such as httpd (Apache web server) or mysqld (MySQL Database server)? You can use /proc file system or the lsof command to find all the file descriptors used by a process. /proc File System Example Find out process ID using the ps command, [...]
This comes up in discussions almost every new project I work on, because it’s a very important thing to consider when designing a database. When deciding when and how to create an index in your MySQL database, it’s important to consider how the data is being used. Let’s say you have a database of employees. [...]
How about backing up all the databases in the server? That’s an easy one, just use the –all-databases parameter to backup all the databases in the server in one step. mysqldump –all-databases> alldatabases.sql How to Backing up only the Database Structure in MySQL You can backup only the database structure by telling mysqldump not to [...]
This guide explains how to set up WebDAV with Apache2 on a CentOS 5.5 server. WebDAV stands for Web-based Distributed Authoring and Versioning and is a set of extensions to the HTTP protocol that allow users to directly edit files on the Apache server so that they do not need to be downloaded/uploaded via FTP. [...]
LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on a CentOS 5.5 server with PHP5 support (mod_php) and MySQL support. I do not issue any guarantee that this will work for you! 1 Preliminary Note In this tutorial I use the hostname server1.example.com with [...]
#!/bin/bash # Shell script to backup MySql database # To backup Nysql databases file to /backup dir and later pick up by your # script. You can skip few databases from backup too. # ——————————————————————– # This is a free shell script under GNU GPL version 2.0 or above # Copyright (C) 2004, 2005 nixCraft [...]
Sometimes, when you have got a large number of tables in your database and while taking the dump of that particular database, you would have encountered this strange error mysqldump: Got error: 1016: Can’t open file: ‘.\database\certain_table.frm’ (errno: 24) when using LOCK TABLES There are two solutions to avoid this error 1. Set the following [...]
Today working on a client project, a shell script which uses MySQL to dump the database, has got me into this error mysqldump: Got error: 1045: Access denied for user I was typically amazed getting this error because all my configurations were correct. I have created proper users to access MySQL database and correctly [...]
8 Install Razor, Pyzor And DCC And Configure SpamAssassin Razor, Pyzor and DCC are spamfilters that use a collaborative filtering network. To install them, run apt-get install razor pyzor dcc-client Now we have to tell SpamAssassin to use these three programs. Edit /etc/spamassassin/local.cf so that it looks like this: # This is the right place [...]
