Category Archives: Linux

Corrupted MySQL database: If you suspect data corruption in a MySQL database, First make a copy of the database for safe keeping: mysqldump –user=root post_planner > /tmp/post_plannerdb.sql Prove it: To prove that the database is corrupted, do: mysql> check database … Continue reading →

Step # 1: Open sshd_config file # vi /etc/ssh/sshd_config Step # 2: Specify a user Only allow user king to login by adding following line: AllowUsers king Step # 3: Restart sshd Save and close the file. In the above … Continue reading →

If you don’t have root access in your mysql instance and want to change the time_zone, you’ll have to change it in the code: To have the time zone setup as you would like, you would you need to execute … Continue reading →

Quick answer: Put this in the user’s wp-config.php file: define(‘FS_METHOD’, ‘direct’); If you are having trouble updating the core wordpress, remember that no matter what the permissions are, wordpress needs it to be owned by apache:apache.

To redirect traffic from one db to another (as a temporary measure if you have multiple places in your app to change the login data) you might try this: iptables -t nat -A PREROUTING -p tcp –dport 3306 -j DNAT … Continue reading →

Sometimes you have multiple php scripts that send email and want to find out which one sent a specific email. I followed the instructions here: http://www.iezzi.ch/archives/217 Worked like a charm.

To establish a subversion repository anew: svnadmin create /var/svn/myrepos svn mkdir -m “creating the trunk dir” file:///var/svn/myrepos/repo1 svn import -m “Adding first directory” /var/www/vhosts/mydomain.com/wordpress file:///var/svn/myrepos/repo1 **Note that if you don’t specify a directory to copy, subversion is happy to add … Continue reading →

Grep is a powerful tool. It can do many things well. It can also be used in conjunction with other tools. If you are new to grep, it is a supercharged search tool. The basic format of the command is: … Continue reading →

zend_mm_heap corrupted if php5.2. google for patch if php5.3 increase apc memory size in apc.ini