http://www.cpanelconfig.com The complete guide to setup and manage a cPanel based server Tue, 18 Nov 2008 08:24:14 +0000 http://backend.userland.com/rss092 en Step 1: DNS: A Record First we’ll need to log in to WHM. Under DNS Functions, select Edit DNS Zone. Choose the domain for the zone in which you wish to edit. Add an A record mapped to asterisk (wildcard) for the subdomain and the IP Address the site is hosted ... http://www.cpanelconfig.com/how-to/setting-up-wildcard-dns-subdomains-on-cpanel/ In this article I will be explaining how to backup the MBR record of a hard-drive. The MBR record contains the partition table and bootloader. Having a backup of the MBR is useful in case you want to copy data from an older drive to a new one or in case you ... http://www.cpanelconfig.com/general-work-on-cpanel-servers/basic-linux-commands-for-linux-based-servers/backup-partition-table-and-bootloader/ What is the screen command? First of all I will start by telling you what you can do using the "screen" command. Many times as a linux sysadmin you will need to run multiple commands at once. You are probably doing this by opening multiple ssh sessions but there is a better ... http://www.cpanelconfig.com/general-work-on-cpanel-servers/basic-linux-commands-for-linux-based-servers/using-the-screen-command/ Hello. To dump a query to csv use this: mysql  --database=database --execute="select a from b where a>1;" | sed 's/\t/","/g;s/^/"/;s/$/"/;s/\n//g' > filename.csv http://www.cpanelconfig.com/tips/mysql-execute-query-from-console-and-export-to-csv/ Hello. I want to share some helpful exim commands for large mailservers: 1. froze messages to recipient root@host.localhost.com /usr/sbin/exiqgrep -i -r root@host.localhost.com | /usr/bin/xargs exim -Mf 2. delete frozen messages /usr/sbin/exiqgrep -z -i | /usr/bin/xargs exim -Mrm 3. delete messages older than X hours (X in seconds) /usr/sbin/exiqgrep -o X -i | /usr/bin/xargs exim -Mrm 4. total ... http://www.cpanelconfig.com/tips/exim-commands/ Hello. I had a trouble some time ago: i wanted to dump a large table (38 million rows, 5G size) without locking the table because the website can't go down. So, here is the mysqldump command: mysqldump --skip-add-locks --skip-lock-tables database > database.sql or for just a table: mysqldump --skip-add-locks --skip-lock-tables database table > ... http://www.cpanelconfig.com/tips/mysqldump-without-locking-tables/ Hello. I found this browsing. I think it will be helpful to post it in here. Here it is: adddns - Adds a DNS zone. addfpmail - Add frontpage mail extensions to all domains without them. addfpmail2 -Add frontpage mail extensions to all domains without them. addnetmaskips - Add the netmask 255.255.255.0 to all IPs ... http://www.cpanelconfig.com/tips/cpanel-scripts-folder-with-explanation-of-every-script/ This is something that I recently come across and I thought that a tiny tutorial is needed here. CentOS 5.x comes with vi as the default editor so when you run: crontab -e "Vi" is the editor that opens up. I personally don't like it and I wanted to change it to the good ... http://www.cpanelconfig.com/tips/change-the-default-crontab-editor/ This is an important announcement from cPanel.net: New cPanel builds have been published tonight to improve installation, speed, memory usage and upgrade experiences. Recently, installs and updates have been taking excessively long due to CPAN module tests during the Perl module updates. New EDGE, CURRENT and RELEASE builds 11.23.3 build 25946 ... http://www.cpanelconfig.com/cpanel-and-whm-news/new-builds-published-to-improve-installer/ This is an important news alert from cPanel.net Currently, RedHat is shipping an older version of coreutils which contains a known bug in /bin/pwd. If a parent directory to the directory /bin/pwd is executed in does not have read permissions, /bin/pwd will fail with the following error: /bin/pwd: cannot ... http://www.cpanelconfig.com/cpanel-and-whm-news/binpwd-broken-in-rhel-and-centos-5/