This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
date -s "`LANG=C date`" |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
//日付指定とJSTの時差分追加 | |
$e->setProperty( 'DTSTART' | |
, $split_matches[0], $split_matches[1], $split_matches[2], $split_matches[3], $split_matches[4], 00, "+090000" ); // 24 dec 2007 19.30 | |
?> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# fdisk -l | |
ディスク /dev/sda: ヘッド 255, セクタ 63, シリンダ 4462 | |
ユニット = シリンダ数 of 16065 * 512 バイト | |
デバイス ブート 始点 終点 ブロック ID システム | |
/dev/sda1 * 1 13 104391 83 Linux | |
/dev/sda2 14 144 1052257+ 82 Linux スワップ | |
/dev/sda3 145 4462 34684335 83 Linux |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# pecl install channel://pecl.php.net/ssh2-0.11.3 | |
WARNING: channel "pecl.php.net" has updated its protocols, use "pecl channel-update pecl.php.net" to update | |
downloading ssh2-0.11.3.tgz ... | |
Starting to download ssh2-0.11.3.tgz (23,062 bytes) | |
........done: 23,062 bytes | |
5 source files, building | |
running: phpize | |
sh: phpize: コマンドが見つかりません | |
ERROR: `phpize' failed |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
$ ldd netExtender | |
linux-vdso.so.1 => (0x00007fff1bbff000) | |
libssl.so.6 => not found | |
libcrypto.so.6 => not found | |
libutil.so.1 => /lib/x86_64-linux-gnu/libutil.so.1 (0x00007f3ad922a000) | |
libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0 (0x00007f3ad900d000) | |
libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007f3ad8c50000) | |
/lib64/ld-linux-x86-64.so.2 (0x00007f3ad9448000) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
INSERT INTO user (Host,User,Password) VALUES('localhost','wordpress',PASSWORD('xxxxx')); | |
CREATE DATABASE wordpress; | |
GRANT ALL ON wordpress.* to wordpress@localhost; | |
FLUSH PRIVILEGES; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
select | |
IF(FLAG=1,'OK','NG') | |
from | |
DATA | |
where | |
ID = 001 | |
INTO OUTFILE "/tmp/test.csv" FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#ルートディレクトリ内に1GBのファイル「swap」を作成 | |
dd if=/dev/zero of=/swap bs=1G count=1 | |
↓ 修正!メモリが少ない環境だと作れないから | |
dd if=/dev/zero of=/swap bs=10M count=100 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Copyright © y-kawaz氏 | |
# 15分でOK!ServersMan@VPSにSL6(≒CentOS6)を入れる方法 | |
# URL:http://d.hatena.ne.jp/y-kawaz/20110722/1311275547 | |
# Mod:snicker_jp | |
# 作業のジャマなので不要なプロセスを停止 | |
/etc/init.d/ajaxterm stop | |
/etc/init.d/crond stop | |
/etc/init.d/httpd stop | |
/etc/init.d/saslauthd stop |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE TABLE data as | |
select | |
ID, | |
sum(PAY_MONEY) as PAY_MONEY | |
from | |
SALES | |
where | |
ID in ( | |
'AAAA', | |
'BBBB', |