You can easily restore or import MySQL data with mysql command itself. First you need to login to your system using ssh or putty(from Windows based system). For example: Login to SSH (make sure you have access to  SSH, contact your hosting provider) Now type following command to import sql data file: $ mysql -u username -p -h localhost data-base-name < data.sql If you have dedicated database server, replace localhost…

while running PHP as fastcgi (mod_fcgid) and you encountering 500 server errors whenver you upload larget attachments? Okay, you just wan’t to know how to fix this? Easy. After switing back to mod_fcgid, you need to log in the terminal as root and open the php.conf file. /usr/local/apache/conf/php.conf (This is the cpanel apache location, you might need to change it to your actual file location) You need to add the…

Error: Site preview in cPanel not working using the URL: http://ip-address/~username Fix: Login to WHM Navigate to WHM -> Security -> Security Center Click on Apache mod_userdir tweak. If the tweak is enabled, you will not be able to access via ~username.

Manually Upgrade from MailEnable to SmarterMail WARNING:  THIS IS ADVANCED AND COULD MESS UP YOUR SERVER.  PROCEED WITH CAUTION! Manually Upgrading from MailEnable to SmarterMail 1)  Run Services.msc. a) For each “MailEnable” Service, STOP it and set its Startup Type = Disabled 2)  Install SmarterMail 3)  Log into Plesk a)  Go to Home > Server Components > Refresh; Go to Home > Server Components > Mail Server and select: MailServer…

If your server is configured to allow .htaccess files, adding the following line will turn off Magic Quotes: php_flag magic_quotes_gpc off

We’ll guide you through installing and configuring CSF – Config Server Firewall, a popular alternative to APF. CSF comes with LFD and works with or without cPanel. CSF Install Guide and How To CSF – Config Server Firewall is a stateful packet inspection firewall, login/intrusion detection and security application for Linux servers. What does that mean in English? Simple – it’s a program that can greatly improve your dedicated server…

How to install mod_security for Apache What is mod_security? ModSecurity is an open source intrusion detection and prevention engine for web applications. It operates embedded into the web server, acting as a powerful umbrella – shielding applications from attacks. ModSecurity supports both branches of the Apache web server. mod_security is great and I encourage it be used by everyone; it does have the potential to break some web applications but…

Installing Subversion with Cpanel/WHM Spent the last 6 hrs breaking my head with installing Subversion and configure it with dream weaver for my client. Though the svn install went though fine had problem with mod_security blocking connections through Dreamweaver Details in the last portion. Before Installing i would recommend you run easyapache to get the latest apache. Installing Subversion: mkdir -p /usr/local/src/subverison cd /usr/local/src/subversion wget http://subversion.tigris.org/downloads/subversion-1.6.6.tar.bz2 tar xfj subversion-1.6.6.tar.bz2 cd…

How to copy files to remote server over ssh scp stands for secure cp (copy), which means that you can copy files across an ssh connection that will be encrypted, and therefore secured. You can this way copy files from or to a remote server, you can even copy files from one remote server to another remote server, without passing through your PC. Usage scp [[user@]from-host:]source-file [[user@]to-host:][destination-file] Description of options…

tar.gz is nothing but compressed tar archive. The tar program provides the ability to create tar archives, as well as various other kinds of manipulation. For example, you can use Tar on previously created archives to extract files, to store additional files, or to update or list files which were already stored. Initially, tar archives were used to store files conveniently on magnetic tape. The name “Tar” comes from this…