Archive for March, 2008

mysqladmin flush-hosts

Host ‘…’ is blocked Error If you get an error like this: Host ‘hostname’ is blocked because of many connection errors. Unblock with ‘mysqladmin flush-hosts’ This means that mysqld has gotten a lot (max_connect_errors) of connect requests from the host ‘hostname’ that have been interrupted in the middle. After max_connect_errors failed requests, mysqld assumes that [...]

/bin/rm: Argument list too long

If you try to remove some file and recive that error. Then one solution is to combine find with xargs. find . -name ‘spam-*’ | xargs rm This will send one line to the rm command. If the filenames involved have spaces, you will need to do use find’s “-print0″ option in conjunction with xargs’s [...]

How to Use SSH

This is the most simplest tutorial of SSH. I had been surfing the Internet for a long time to get this done, but it was not getting done. Here are the steps that anyone should follow.

How to restore/repair/recover a mySQL Database/Table

From time to time mySQL databases can get corrupt, whether it due to lack of disk space, power failure, or just an error. Repairing MyISAM mySQL Tables/Databases: cd /var/lib/mysql/DBNAME #^ Please note that we assume your mySQL data directory is /var/lib/mysql myisamchk *.MYI Repairing ISAM mySQL Tables/Databases: cd /var/lib/mysql/DBNAME #^ Please note that we assume [...]

Viewing .htaccess via FTP using Total Commander

If you are using Total Commander, and you didn’t see the hidden files from a remote ftp server. Then you should edit wcx_ftp.ini (standard installation it’s in c:\windows\wcx_ftp.ini ) After the [General] section please add FtpShowHidden=1 Save the file, restart the Total Commander, and after that you should see all files.