How to find the latest queries run in MySQL
Run the following queries – SET GLOBAL log_output = 'TABLE'; SET GLOBAL general_log = 'ON'; After the latest 100 queries executed after this is done can be foun...
Month: September 2012
Activate password authentication on Ubuntu VMs on Amazon EC2
ssh -i [path to private-key-file] [target IP] # In the host shell sudo adduser [username] # Add a new user; this command also prompts for setting the passwo...
Extract .gz file using gzip without deleting the original file
Extract the .gz file to standard output (option -c) and pipe this to target file. # example <pre><code>gzip -c inputfile.gz > outputfile</code...