by Aromal Rajagopal | Sep 18, 2009 | Quick fixes, Technical |
Issue : After downloading a database backup through cPanel (Download a MySQL database back-up) , the tar file generated is empty! Solution : This usually happens when you are logged in to cPanel with the root/reseller password. Log in with the user password and then...
by Aromal Rajagopal | Sep 18, 2009 | Quick fixes, Technical |
Issue : How to prevent anybody from accessing MySQL databases hosted on the server from any local PC ? Solution : This can be achieved in two ways : 1. By blocking the port 3306 . You can use iptables in order to do this : /sbin/iptables -A INPUT -i eth0 -p tcp...
by Aromal Rajagopal | Aug 19, 2009 | Quick fixes, Technical |
Issue : Following error shows up on the websites which run with mysql. Warning: session_write_close() [function.session-write-close]: write failed: No space left on device (28) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php on line 42 Restarting MySQL fixes...
by Aromal Rajagopal | Aug 18, 2009 | Quick fixes, Technical |
Issue : How to login to PHPMyAdmin directly (without logging in to the cPanel interface) ? Solution : This can be achieved by the following steps : First, download and untar the latest version in to your public_html folder. wget...
by Aromal Rajagopal | Jul 30, 2009 | Quick fixes, Technical |
Issue: Cron job required for scheduling automatic checks and repairs on MySQL Databases. Solution : Use the following cron : 0 1 * * * /usr/bin/mysqlcheck -Aao –auto-repair -u -p” Please note that this will show your MySQL password in the process list. You...