To export MySQL results to an outfile or CSV file: SELECT column_name FROM table_name INTO OUTFILE '/var/lib/mysql-files/export.csv'; If you receive the following error: The MySQL server is running with the…
Export MySQL results to outfile/CSV
Atom editor selects text when left click and scroll
Atom on Ubuntu has a strange bug with X which behaves strangely after clicking and scrolling. All text is selected up to the scrolled point after clicking and releasing the…
Find all unread mail Gmail
Have you been scrolling through hundreds of pages to find the unread mails? No need for that, simply type the following in Gmail search: is:unread
The Linux Creative Paradox
In many cases, being liberated from the grips of commercial software does not mean professional-grade graphics cannot be created. Patience and enthusiasm are required to demonstrate that Adobe isn't the…
Change Git remote URL
If you need to change the URL for your git repository you will need to update the url by issuing the following command: git remote set-url origin YOUR-NEW-REPOSITORY-URL.git You can…
How To Install GitKraken on Ubuntu
GitKraken is a popular leading graphic user interface for Git which was built using NodeGit. To download and use GitKraken you're going to need Ubuntu 12.04 or later. Assuming you…
Change directory Ghost
If you need to change the name of the root directory of your ghost installation, there are a couple of steps you'll need to take to ensure everything functions as…
Useful commands to setup MySQL in Docker
Create a MySQL Docker container docker run –name my-container-name -e MYSQL_ROOT_PASSWORD=my-secret-pw -d mysql Login to Docker container bash / terminal docker exec -it mysql bash Create MySQL database in Docker…
Augmented reality is approaching
Augmented reality is a technology being furiously developed by tech giants such as Facebook. How about a pair of glasses which allows you to “project” a screen anywhere and interact…
Remove password from PDF Ubuntu
A neat little utility to remove the password from a PDF is qpdf. To get started install qpdf sudo apt-get install qpdf Remove the password using the following command qpdf –password=YOUR-PASSWORD-HERE…









