xlulu's blog

Due to the php version compatibility issue with php-cgi, the apache does not work with suphp. If you get your php version with 5.2.17-13, here is a temporary fix by downgrading your php version to 5.2.17-1.

# backup php.ini
cd /etc
yes | cp -rf php.ini php.ini.bck
cd /

# downgrade to get old version
rpm -e –nodeps php
rpm -e –nodeps php-cli
rpm -e –nodeps php-common
rpm -e –nodeps php-fpm
yum install php-5.2.17-1

# copy to old version
yes | cp -rf /usr/bin/php /usr/bin/php_pure
yes | cp -rf /usr/bin/php-cgi /usr/bin/php-cgi_pure

# make suphp call old version instead new one
cd /usr/local/lxlabs/kloxo/file/
yes | cp -rf etc_suphp.conf etc_suphp.conf.orig
sed -i ‘s/\/usr\/bin\/php-cgi”/\/usr\/bin\/php-cgi_pure”/’ etc_suphp.conf
cd /etc
sed -i ‘s/\/usr\/bin\/php-cgi”/\/usr\/bin\/php-cgi_pure”/’ suphp.conf

# restore php.ini
yes | cp -rf php.ini.bck php.ini

cd /

# back to upgrade
yum upgrade php*

reboot

1. How to find the latest file on Unix or Linux (recursive)

   find . -type f -printf "%TY-%Tm-%Td %TT %p\n" | sort -r | head -n 1

2. Remove files which include specific contant

   find ./ -type f | xargs -n 10 grep -l "STRING" | xargs rm

3. Count files
   only for normal files：

   ls -lR /path/to/dir | grep '^-' | wc -l

   including hidden files：

   ls -laR /path/to/dir | grep '^-' | wc -l

   including hidden files, soft links, Charactor, Block ：

   ls -laR /path/to/dir | grep '^[-lcb]' | wc -l

This hack is to add a reminder message at the heading area when members have not yet got their Email validation done.

1. includes/lib_main.php

Find the following codes:

<blockquote>$sql = 'SELECT u.user_id, u.email, u.user_name, u.user_money, u.pay_points'.

' FROM ' .$GLOBALS['ecs']->table('users'). ' AS u ' .

" WHERE u.user_id = '$id'";</blockquote>

add “u.is_validated” into the select strings.

2. themes/theme name/library/member_info.lbi

Add following code at where you want to show the message.

<!--{if $user_info.is_validated eq 0} -->
<font>You have not yet completed Email validation, please validate your Email in member center.</font>
 <!--{/if} -->

1. Close Outlook Express. RUN command “msimn /reg” from the Start Menu > Run to register msimn.
2. Open Outlook Express and to the Tools Menu. Select Options. On the General tab, look down to the Default Messaging Programs. More than likely, to top option will say that “This application is NOT the default Mail handler” Click the button next to it that says “Make Default”. This should trigger an available option in Firefox below if it was not already available.
3. In Firefox, go to the Tools menu. Select Options. Click on Applications. Under the column, “Content Type” look for the mailto function. In the column Action, select “Use Outlook Express (default)” if it is not already selected. “(default)” must be part of the phrase. Somehow there is code behind this option that will bring up a new e-mail in Outlook that otherwise does not work if Outlook is selected manually.

mysql –user=YOUR_USERNAME –password=YOUR_PASSWORD -BNe “show tables” YOUR_DBSCHEMA_NAME | tr ‘\n’ ‘,’ | sed -e ‘s/,$//’ | awk ‘{print “SET FOREIGN_KEY_CHECKS = 0;DROP TABLE IF EXISTS ” $1 “;SET FOREIGN_KEY_CHECKS = 1;”}’ | mysql –user=YOUR_USERNAME –password=YOUR_PASSWORD YOUR_DBSCHEMA_NAME

Add follow code to index.php

if ($_SERVER['REMOTE_ADDR'] != '192.168.1.100')
{
 require 'down.htm';
 die();
 }

The code will redirect visitors from all IPs except for 192.168.1.100 to down.htm page.

flush cache

rm -rf var/cache/ var/session/ var/report/

Backup files from public_html/magento directory

tar -zcf filename.tar.gz

Read more…



符號表引用自頂客論壇：http://www.dk101.com/Discuz/viewthread.php?tid=116102

The following steps are how to dump the whole database of a MySql server and then restore them:

1. Dump all databases by calling:
   

   mysqldump -uroot -p –extended-insert –all-databases –add-drop-database –disable-keys –flush-privileges –quick –routines –triggers > all-databases.sql

2. Stop the MySQL server;
3. Rename or remove (in case you’ve already backed it up) the MySQL data directory;
4. Make the appropriate changes in my.cnf;
5. Re-initialize the database with the following command:
   

   mysql_install_db

6. Start the MySQL server;
7. Get into the ‘mysql‘ console and type:
   

   SET FOREIGN_KEY_CHECKS=0;
   SOURCE all-databases.sql;
   SET FOREIGN_KEY_CHECKS=1;

8. Restart the MySQL server.

MySQL: How to Force MySql Drop Tables with Foreign Key

mysql> SET foreign_key_checks = 0;
mysql> drop table …
mysql> SET foreign_key_checks = 1;