How to fix chroot return "Exec format error"
A chroot Exec format error in Red Hat/CentOS rescue mode usually means the running environment and target commands use different architectures.
THE KNOWLEDGE BASE
All articles.
389 notes on Linux, tools and troubleshooting
How to count blank lines and non-blank lines in a file
Shell techniques for counting blank and nonblank lines in a file, useful in scripts and troubleshooting.
Export mysql database based on a where condition
MYSQLDUMP exports data from MySQL databases. It is commonly used to export all data from a table or database, but it can also export selected data…
How to read pcap file in Linux CLI using tcpdump
pcap files from tcpdump or network devices are binary and cannot be read in ordinary text editors. tcpdump can read them directly from the Linux console.
Installing MySQL 5.6 using the MySQL yum repository
Oracle has released a MySQL Yum repository to make installing and updating MySQL server easier. Initially it supports Red Hat/Oracle Enterprise Linux/CentOS 6 and Fedora 18 and 19…
[Bug] Invalid of GRANT command will breaks replication
MySQL 5.6 has a bug to watch for: running GRANT privileges in PhpMyAdmin may cause a slave to stop replicating (bug report: http://bugs.mysql.com/bug.php?id=68892). After using MySQL 5…
How to redirect stdout and stderr to log file
How to redirect standard output and standard error to a log file. Correct syntax: command > /path/to/log 2>&1. This redirects stdout to the log and stderr to stdout.
How to compress mysqldump output with gzip/bzip2
mysqldump exports MySQL data in SQL format and is commonly used for backups. Normally these backups are not compressed.
How to list stored procedures and show procedure code in MySQL
To list the stored procedures in MySQL and display their procedure code, follow these steps. Listing MySQL stored procedures: list the procedures in the system. mysql> SHO…