Skip to content

Instantly share code, notes, and snippets.

Avatar

xuan exuan

View GitHub Profile
View mysql5.7-install
cmake . -DCMAKE_INSTALL_PREFIX=/data/database/mysql \
-DWITH_BOOST=../boost_1_63_0 \
-DSYSCONFDIR=/data/database/mysql \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DWITH_FEDERATED_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DENABLED_LOCAL_INFILE=1 \
-DENABLE_DTRACE=0 \
@exuan
exuan / git-config-core-ignorecase.md
Created Aug 1, 2016
git 默认不区分文件名大小写, 被黑的欲仙欲死
View git-config-core-ignorecase.md

git 默认不区分文件名大小写, 被黑的欲仙欲死, 需要关闭ignorecase

$ git config --global core.ignorecase false
View mysqlbinlog-decode.md
[root@localhost ~]# /usr/local/mysql/bin/mysqlbinlog --base64-output=DECODE-ROWS -v  /data/database/3306/data/mysql-bin.000034
@exuan
exuan / php7-configure.md
Last active May 24, 2016
php7 安装配置
View php7-configure.md

配置参数引用2015博客升级记(五):CentOS 7.1编译安装PHP7

  ./configure \
--prefix=/usr/local/php7 \
--exec-prefix=/usr/local/php7 \
--bindir=/usr/local/php7/bin \
--sbindir=/usr/local/php7/sbin \
--includedir=/usr/local/php7/include \
--libdir=/usr/local/php7/lib/php \
@exuan
exuan / purge-binay-logs.sql
Created Oct 26, 2015
清理MySQL bin log
View purge-binay-logs.sql
PURGE BINARY LOGS BEFORE DATE_SUB( NOW( ), INTERVAL 3 DAY);
PURGE BINARY LOGS TO 'mysql-bin.000082';
/**
* 重置
*/
RESET MASTER;
@exuan
exuan / excel-form.php
Last active Oct 19, 2015
phpexcel 画一个排期
View excel-form.php
<?php
$charts = array(); //26 * 27
for($i = 65; $i <91; $i++) {
$charts[] = chr($i);
}
for($i = 65; $i <91; $i++) {
$char = chr($i);
for($j = 65; $j <91; $j++) {
$charts[] = $char . chr($j);
}
@exuan
exuan / getExtension.php
Created May 4, 2015
获取文件后缀
View getExtension.php
echo pathinfo($file, PATHINFO_EXTENSION);
View chrome_extension_get_cookie.js
You can’t perform that action at this time.