Mysqldump multiple database , tables
Dump multiple databases: mysqldump -u root -p --databases db1 db2 db3 > Dump some selected tables: mysqldump -u mysqlusername -p databasename table1 table2 table3 > Dome all tables...
How to receive notification when a SSH connection established
1. Set all ssh account to use bash shell by default , /etc/passwd 2. Make sure that you have install exim or postfix or any other email tool to...
Can’t install software because /boot is full
When you run apt-get install , you got some error this dpkg: dependency problems prevent configuration of linux-server: linux-server depends on linux-image-server (= ); however: Version of linux-image-server on...
Palo Alto PA500 , Yahoo, Draytek Vigor 2930
For some reason, when Vigor with Firmware , it doesn’t work well with Palo Alto PA500 , especially Yahoo. When Palo Alto make the request with cookies >...
ubuntu 16.04 nagios libmysqlclient.so.18
my mysql nagios plugin doesn’t work, tested with this command /usr/lib/nagios/plugins/check_mysql Error error while loading shared libraries: : cannot open shared object file: No such file or directory It’s...
How to setup Subversion + Apache
A complete guide If you want to setup a tool to manage the subversion over web , try
Mysql 5.7 : How to enable slow query logs
If you just uncomment the slow query log variable in , you can’t start your mysql server. it’s because the variable name has changed, the following configuration works...
Fixing OpenSSL Padding Oracle vulnerability (CVE-2016-2107)
This works well on my Ubuntu # Based on Method1: $ sudo apt-get update $sudo apt-get install –only-upgrade openssl #check if it patches successfully. $ zgrep...
Allowing Slashes in URL with Apache
I have a url like this so in normal situation, we only have 3 sub folder: countries,us,12/pensylvainia , but in Apache2 , it treats this as 4 :...
Mysql – repair/check all tables in all databases
The below command will go through all tables in all database databases to do a repair check. mysqlcheck -uroot -p -A --auto-repair