Every once in a while, you may find that the file system you are using is full. Usually this will manifest with a message like: No space left on device When this happens, check if the file system is under Logical Volume Management or LVM. You can do this a number of ways, but a […]
Resizing LVM Volumes & File Systems in Linux Via SSH Read More »
We can use the usermod command to add a user to a group. Here I am going to add the user grokman to the group adm: root@myserver:~# sudo usermod -aG adm grokman root@myserver:~# exit Connection to myserver closed. root@myserver:~# ssh myserver Welcome to … root@myserver:~# groups admin adm sudo www-data In Debian / Ubuntu, the
Add User to Group In Linux Read More »
When using MySQL (or most any DB really), it’s a good idea to understand about collation: the implications, the defaults, and how to change it. Collation determines how data is sorted and compared in the database. Its essentially a set of rules for the DB to follow when making decisions on said sort and comparison.
MySQL Collation & Case Sensitivity or Insensitivity Read More »
One way to monitor DB activity in MySQL is to enable logging and then tail the log file. mysql -u root -p You can check the status of logging and get the path of the log file with: SHOW VARIABLES LIKE "general_log%"; And then enable logging with: SET GLOBAL general_log = 'ON'; Finally, tail the
Monitor MySQL DB Activity Read More »
On some platform / shell combos, you may find Git has gone hog-wild with the paging. I.e., you may find it pages things like logs & diffs when there is not even a single page of information in the first place. In this situation, I have found the following Git global config can resolve the
Prevent Git From Paging When Not Needed Read More »
To login to MySQL / MariaDB as the root user, you will need sudoers perms and then you can issue the following command: /home/grokman grokman@li598-26% sudo mysql -u root -p So, it should go something like this:
MySQL / MariaDB Root User Login Read More »
In order to list all the configured DB users in a MySQL or MariaDB, you must be logged in as an administrator: /home/grokman grokman@li598-26% sudo mysql -u root -p Then you can issue the command to list all the DB users: select user, Super_priv from mysql.user; So, it should go something like this: Other user
MySQL List Users Command – How to Show / List All Users in MySQL / MariaDB Read More »
If you are staring at a lot of files like logs, and trying to look at only stuff that’s changed lately, it can be helpful to filter them out first. One such way is with the find command. Eg, to to list files modified in the last 24 hours: find . -mtime -1 -print
Linux: List Recently Modified Files Read More »
To delete all blank lines in vim: :g/^$/d “:” -> enter command-line mode “g” -> do the action globally (apply it to all lines to which the subsequent match applies) “/^$/” -> regex to mean “a line is a match if it contains nothing from start to finish” “d” -> the action to do for
vim – delete all blank lines Read More »
Don’t you just love a piece of software that has stood the test of time, and averted relegation to the wistful days of yore?? rsync is a perfect example of this. How has rsync achieved this? Well, you see, rsync is awesome! Say you have a folder on a remote machine that you want to
Getting Files Delta From A Remote Folder Using rsync Read More »