Hello,
I wanted to export the csv file from MySQL command line. And used the guide following the article [HOW TO] Export mysql result to csv file.
All are good if there is no any issue.
mysql> select * from devices where status = '2' INTO OUTFILE '/tmp/PLC_active.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n';ERROR 1290 (HY000): The MySQL server is running...
[HOW TO] install Visual Studio Code in Arch Linux
I am moving Linux working environment from Ubuntu to Antergos. And I need to install Visual Studio Code for working with Git.
Also saw something on this progress that is needed for newbie. So I write down this article. Hope it can be help you faster.
This article follows step-by-step theory, so it is easy to do.
Step 1:
You must download git repository
[root@cliff...
[HOW TO] fix ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
Hey guys,
I am working with MySQL, then want to export the data to csv file.
mysql> select name,address from devices into outfile '/tmp/devices.csv' fields terminated by ',' enclosed by '"' lines terminated by '\n';ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
Oops! unlucky, it returns the error. Before me,...
[HOW TO] set application log to rsyslog on Ubuntu server
Depending on your application, also your purpose, you want to direct the log to fixed log path. So, if you are using rsyslog as a syslog service on Ubuntu, please follow this article.
I am using trigger to do this.
Go to log path
root@sta-tn:/etc/rsyslog.d#
then write a sub-rsyslog configuration.
root@sta-tn:/etc/rsyslog.d# vim 10-sta.conf
if $programname == 'STA' then {
/var/log/sta.log ...
[HOW TO] The following signatures couldn't be verified because the public key is not available: NO_PUBKEY
sky@zabbix4-srv-01:/opt/packages$ sudo apt-get updateGet:1 http://repo.zabbix.com/zabbix/4.0/ubuntu xenial InRelease [7096 B]Hit:2 http://security.ubuntu.com/ubuntu xenial-security InReleaseGet:3 http://ppa.launchpad.net/ondrej/php/ubuntu xenial InRelease [23.9 kB]Hit:4 http://us.archive.ubuntu.com/ubuntu xenial InReleaseGet:5 http://repo.zabbix.com/zabbix/4.0/ubuntu xenial/main Sources [1196 B]Ign:3...