Turbo charging MySQL by setting up the query cache
Posted on 27. Mar, 2009 by wiredgorilla.
To make sure MySQL uses the query cache, there are a few variables you need to set in the configuration file . Usually its my.cnf or my.ini so check on your server with the shell command locate , in our case we are running on a CentOS 5.2 distro and to its my.cnf located in [...]
Continue Reading
Moving mySQL DBs between servers
Posted on 27. Mar, 2009 by wiredgorilla.
Moving mySQL DBs from one server to another: mysqldump -uUSER -pPASSWORD txp_database > txp_database.sql puts the entire thing in one nicely portable text file. on a new server it takes mysql -uUSER -pPASSWORD txp_database < txp_database.sql to import it.
Continue Reading
Linux Cron Jobs Explained
Posted on 27. Mar, 2009 by wiredgorilla.
Cron allows users to automate repetitive system administration tasks such as tape backups, database reorganization, and general file cleanups (such as emptying log files and queues). The Crontab File’s Syntax To tell cron what you want it to run, and how often you want it to run it, you need to create a crontab file. [...]
Continue Reading
Taking backup of mysql database using cron
Posted on 27. Mar, 2009 by wiredgorilla.
Taking backup of mysql database using cron Create a file called database_backup.sh and also an empty directory called mysql_backup. The database_backup.sh script should have the following info :
Continue Reading
PRM (Process Resource Monitoring) in Linux Servers
Posted on 26. Mar, 2009 by wiredgorilla.
The great people from R-FX Networks are bringing us a number of powerfull tools for the Linux Server enviroment PRM (Process Resource Monitoring) monitors the process table on a given system and matches process id’s with set resource limits in the config file or per-process based rules. Process id’s that match or exceed the set [...]
Continue Reading
How to Reset your Linux Root Password
Posted on 26. Mar, 2009 by wiredgorilla.
Whenever you can’t remember Root password, you can read this tutorial and do step by step to Reset it … You can log in with single-user mode and create a new root password. Reboot your computer. When GRUB is presenting the menu list, follow those instructions:
Continue Reading
CentOS – what happened to netconfig in 5.1
Posted on 26. Mar, 2009 by wiredgorilla.
For whatever reason CentOS decided to drop netconfig and renamed it to system-config-network
Continue Reading
Common SSH Commands and Linux Shell Commands
Posted on 26. Mar, 2009 by wiredgorilla.
We’ve put together some of the more frequently used SSH commands or linux shell commands, and organized them by name so you can easily find a command, their description and how to use it. This guide will continue to be updated and should not be considered a complete list of SSH commands or linux shell [...]
Continue Reading
The old JavaScript cPanel Server exploit
Posted on 20. Mar, 2009 by wiredgorilla.
The Javascript exploit has been an old saga on a few Linux distros running cPanel and Plesk . The compromise is at the root level and a rootkit has been installed. This rootkit will attach to several syscalls within the kernel and begin serving malicious javascript to random web visitors. This root compromise is not [...]
Continue Reading
CentOS 5.1 Server Setup: LAMP, Email, DNS, FTP, ISPConfig (a.k.a. The Perfect Server)
Posted on 26. Feb, 2009 by wiredgorilla.
This tutorial shows how to set up a CentOS 5.1 based server that offers all services needed by ISPs and web hosters: Apache web server (SSL-capable), Postfix mail server with SMTP-AUTH and TLS, BIND DNS server, Proftpd FTP server, MySQL server, Dovecot POP3/IMAP, Quota, Firewall, etc. This tutorial is written for the 32-bit version of [...]
