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
Solve error 1290 –secure-file-priv MySQL
If you're encountering the following error: The MySQL server is running with the –secure-file-priv option so it cannot execute this statement This is generally as a result of exporting results…
Import single table into MySQL
To import a single table into MySQL: mysql -u username -p database_name < table_name.sql View related article Export single table MySQL
How to Install Lightworks on Ubuntu
Lightworks is an open source non-linear video editing system which is probably the best available at the 'freemium' price range. Before you begin installation, please make sure that your system…
What is GitKraken?
Axosoft ™ GitKraken is an open source command-line interface that is according to their website, cross-platform and made by devs for devs. It was built to for working with the…
Export single table MySQL
If you receive the following error: Error 2020: Got packet bigger than max_allowed_packet bytes when dumping table This normally occurs as a result of a particular table exceeding the max_allowed_packet…
How to Install RawTherapee on Ubuntu
RawTherapee is a program for developing raw photos and processing images in the common formats. It has a simple and easy-to-use interface. It is non-destructive, makes use of OpenMP, supports…
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…
How to Download Liquid Rescale for Ubuntu
The plugin is included in Debian and in Ubuntu, in the package “gimp-plugin-registry”, which also includes some other great plugins. To get started, open your terminal with: Ctrl+Alt+T Then run…
Install Unifi controller on Ubuntu
Installing Ubiquiti's Unifi controller on Ubuntu is fairly straight forward. The first step is to install the Unifi controller with the following commands: deb http://www.ubnt.com/downloads/unifi/debian stable ubiquiti sudo apt-key adv…
