How to empty a MySQL database via SSH or phpMyAdmin

There are two ways to empty a MySQL database: via phpMyAdmin and SSH. NOTE 1: By default, SSH access is disabled on all our shared servers. If you need SSH to be enabled, contact our Hosting support via Live Chat or submit a ticket to the Hosting Support department. NOTE 2: We recommend making a backup of your database before proceeding with any changes. […]

Continue Reading

Common configuration files and directories for cpanel ssh command

You can find common configuration files and directories in the following locations on your server: Exim /etc/exim.conf /var/log/exim_mainlog /var/log/exim_rejectlog /etc/valiases/ /etc/vfilters/ home/username/.forward MySQL® /root/.my.cnf /etc/my.cnf /var/lib/mysql/ Apache 1 2 /usr/local/apache/conf/httpd.conf /usr/local/apache/domlogs/ System 1 2 /var/log/messages /var/log/dmesg ProFTPD /etc/proftpd.conf /var/log/xferlog /etc/proftpd/ SSH /etc/ssh/sshd_config

Continue Reading

cPanel SSH Commands List

Restart chkservd: /etc/init.d/chkservd restart Tail Apache log: tail -f /usr/local/apache/logs/error_log Updates the cpanel server software: /scripts/upcp Reinstalls exim: /scripts/exim4 View traffic or if you think a site is being DDoS: cd /usr/local/apache/domlogs tail -f targetsite.com Correct bandwidth issues /scripts/cleanbw To fix problem in webalizer that stop updating stats /scripts/fixwebalizer Fix everything /scripts/fixcommonproblems /scripts/fixeverything Fixing Mail […]

Continue Reading