日期: 2017 年 2 月 17 日

一、Windows
1.清單檔: listfile.txt

assets\js\plugin\bootstrap-datepicker.min.js
assets\js\plugin\js-xlsx.min.js
WEB-INF\lib\bcprov-jdk16-146.jar
WEB-INF\lib\commons-collections-3.2.1.jar
WEB-INF\lib\commons-lang-2.4.jar

2.備份Shell: backup.cmd

set backuppath=%cd%
set dd=%date:~8,2%
set dm=%date:~5,2%
set dy=%date:~0,4%
set mydate=%dy%%dm%%dd%

D:
cd D:\GWork\Source\workspace\testtadm\WebContent
"C:\Program Files\7-Zip\7z.exe" a -ttar %backuppath%\backup_%mydate%.tar @%backuppath%\listfile.txt

二、Linux
1.清單檔: listfile.txt

assets/js/plugin/bootstrap-datepicker.min.js
assets/js/plugin/js-xlsx.min.js
WEB-INF/lib/bcprov-jdk16-146.jar
WEB-INF/lib/commons-collections-3.2.1.jar
WEB-INF/lib/commons-lang-2.4.jar

2.備份Shell: backup.sh

NOW_PATH=`pwd`
NOW_TIME=`date +'%Y%m%d%H%M%S'`

cd /usr/local/tomcat/webapps/testweb
tar -cvf ${NOW_PATH}/backup_${NOW_TIME}.tar --files-from ${NOW_PATH}/listfile.txt 

PS.執行前請記得chmod +x backup.sh，讓shell檔為可執行狀態

今日在facebook看到有人介紹console.dir()及console.table()，
所以趕緊筆記下來
1.https://developer.mozilla.org/en-US/docs/Web/API/Console/table
2.https://developer.mozilla.org/en-US/docs/Web/API/Console/dir
之前在debug array object或json都覺得很麻煩，
沒想到有這麼方便的工具~

PS.雖然chrome的套件也不錯用
(chrome-extension://lhkmoheomjbkfloacpgllgjcamhihfaj/index.html)

1.至/etc/my.cnf
將以log=/var/log/mysql/mysql_log
調整為#log=/var/log/mysql/mysql_log
即off掉此功能

2.mysql -u [user] -p
輸入密碼後，輸入以下指令
show variables like ‘%log%’;
會顯示log功能已關閉

+---------------------------------+------------------------------+
| Variable_name                   | Value                        |
+---------------------------------+------------------------------+
...
| log                             | OFF                          |