Category Archives: Technology

Execute MySql script from the command line

03/19/2018 Mark Jacobsen Leave a comment

This tip is very similar to how to “Execute a SQL file via the MySQL command line in one line” only this time specifying the DB you want to execute the script against and being prompted for your password…

mysql -u user -p -h localhost MyDb < ~/SQL/script.sql

Please remember to subscribe to the newsletter or feed to stay up to date!

Disclaimer: Thoughts and opinions are my own, and do not reflect the views of any employer, family member, friend, or anyone else. Some links may be affiliate links, but I don't link to anything I don't use myself.

Linux

Using sed to view and replace text on a specific file in Linux

03/17/2018 Mark Jacobsen Leave a comment

Ever need to replace very specific text on a particular line in a very large file on Linux? Enter the sed command.

To view the line (let’s say line 864 in this case) in the specific file, issue this command…

$ sed -n '864'p myfile.txt

And let’s say you get back the string ” I hate cheese”. Since we all know that’s not true, you can use a different variation of the sed command to replace “hate” with “love” like so…

$ sed -i '864s/hate/love/' myfile.txt

And if you’re really curious on how this even came about, it was due to an error in the phpMyAdmin export.php script when you had to change “break 2” to “break” on line 846 as identified here: https://askubuntu.com/questions/928883/500-error-on-phpmyadmin-export-on-phpmyadmin-export-php/930975

Programming

All Code Is Bad, So Don’t Stress If Yours Sucks

02/14/2018 Mark Jacobsen Leave a comment

Some funny for my developer friends. If you don’t program for a living, just ignore everything in these articles because you will become convinced the world will implode shortly. On the other hand, if you do program I’m pretty sure you’ll love this…

Read the full article here, or… check out the summary

Security

Scary Chip Flaws Raise Spectre of Meltdown — Krebs on Security

01/11/2018 Mark Jacobsen Leave a comment

Please be sure to update/patch every device you have. On most Windows machines, you should be able to do a manual reboot (Start -> Power -> Restart) and have the updates applied. On iOS you want to go to Settings -> General -> Software Update

Scary Chip Flaws Raise Spectre of Meltdown — Krebs on Security

Health, iPhone, Technology

The Most Dangerous Thing You Can Do While “Multitasking”

11/19/2017 Mark Jacobsen Leave a comment

So true. Please enable “DND while driving” on your phone! Both the iPhone and Android have the feature. I’ve been using it since I updated to iOS 11, and it works well. Just getting the notifications I found was a distraction, and since I can still get calls from my “favorites” it’s been a huge help.

OPTIMIZE with Brian Johnson | More Wisdom in Less Time: +1 #52: The Most Dangerous Thing You Can Do While “Multitasking”