You are here

cli

Enabling logging for your MySQL queries from the MySQL prompt

Submitted by Druss on Sat, 2016-06-04 01:44

I usually find it a chore to edit the MySQL conf files (as for one, I often have no idea which my.cnf file to edit!) One way to work around this issue, particularly if you want to change a setting temporarily, is to simply enable the change dynamically via the MySQL command prompt. This can be accomplished by modifying "global" variables which can be listed with commands like so:

Set the timezone of a Debian/Ubuntu server from the command-line

Submitted by Druss on Mon, 2014-08-25 19:34

Setting the timezone of an Ubuntu (14.04, Trusty) or Debian (7, Wheezy) server from the command-line is simple. Just run dpkg-reconfigure tzdata and follow the on-screen prompts. However, if you are running an unattended installation, you might want to avoid interactive prompts and just gets the job done. To do this, simply run

$ sudo ln -sf /usr/share/zoneinfo/America/Anchorage /etc/localtime

Browse through /usr/share/zoneinfo/ to locate your timezone.

bash: cannot set terminal process group (3987): Inappropriate ioctl for device bash: no job control in this shell

Submitted by Druss on Wed, 2014-08-20 19:44

On a new Ubuntu 14.04 (Trusty) LTS server, I ran into the following:

$ su -c /bin/bash foo
bash: cannot set terminal process group (3987): Inappropriate ioctl for device
bash: no job control in this shell

However, the su procedure worked and I was logged in as user foo.

Running a program as an administrator in Windows (7)

Submitted by Druss on Sun, 2014-08-03 10:28

Running a program in "privileged" mode (i.e., as an administrator) is as simple as pressing the START button, finding the program, right-clicking its name, and choosing Run as administrator. (You can similarly also choose to Run as different user, but to get this option, you'll need to press SHIFT before the right click.) This should bring up Windows' pop-up asking you to allow the program to be run as administrator where you click Yes and Robert is your uncle.

SVN: Remove/delete .svn directories recursively

Submitted by Druss on Fri, 2014-07-18 01:22

Earlier today, I wanted to recover some files that I'd added to version control (for safe keeping). However, I did not want to retain the pesky .svn files that plague every directory in the tree (unlike the wonderful git). GOOG directed me to solutions that all rely on Linux tools to do the trick. The following does work admirably:

dpkg cannot install as there's no space left on the device even though there is

Submitted by Druss on Thu, 2012-11-22 23:46

I ran into this issue a couple of days ago and cannot recall the exact error message. However, the problem was effectively that aptitude could not install the new kernel update because my partition had apparently run out of space. An interrupted update to Klipper is one thing and the Linux kernel a whole 'nother kettle of fishies. Thinking that I simply needed to free up some space on my partition, I checked the current status via df.

Pages

Subscribe to RSS - cli