Author:
erics , June 12th, 2019
The Problem Tried to load a Tab-delimited text file into MuSQL 5.6.43 and got the following error: mysql> LOAD DATA INFILE ‘sample.txt’ INTO TABLE test_table; ERROR 1290 (HY000): The MySQL server is running with the –secure-file-priv option so it cannot execute this statement Solution One mysql> SHOW VARIABLES LIKE “secure_file_priv”; Copy the file into the […]
Categories: How-To's , Technology Tags: Data , Error , File , howto , INFILE , Load , LOAD DATA , LOAD DATA INFILE , LOAD DATA LOCAL INFILE , local , mysql , Priv , Privilege , Secure , secure_file_priv , secure-file-priv , Show , SHOW VARIABLES , tips , VARIABLES
| No comments
Author:
erics , June 3rd, 2019
To display the filenames included in each commit, just add the –name-only argument to git log:
Categories: How-To's , Technology Tags: Display , File , file names , git , git log , howto , Log , names , Show , tips
| No comments
Author:
erics , February 5th, 2017
rsync -avzn –progress –include=’*.png’ –include=’*/’ –exclude=’*’ /the/source/path/ user@theServer:/the/target/path/
Categories: How-To's , Technology Tags: exclude , Extension , File , Filter , howto , include , PNG , rsync , tips
| No comments
Author:
erics , June 17th, 2016
Jun 17 00:02:45 inbound dovecot: IMAP(yourName): Corrupted index cache file /home/yourName/Maildir/dovecot.index.cache: invalid record size
service dovecot stop
cd / home / yourName / Maildir /
rm dovecot . index*
service dovecot start
As always, YMMV. Proceed with caution.
Categories: How-To's , Technology Tags: AWS , Cache , Cache file , Corrupted , Corrupted index , Dovecot , Email , File , howto , IMAP , Index , Linux , mail , Mailhost , PostFix , tips
| No comments
Author:
erics , September 5th, 2015
SELECT DISTINCT `meta_value` FROM `wp_postmeta` WHERE `meta_key` LIKE '_wp_page_template'
Categories: How-To's , Technology Tags: File , File Name , howto , Page , Template , tips , WordPress
| No comments
Author:
erics , June 30th, 2013
In order to protect a file, just replace the Directory directive with Files:
< Files wp - login . php >
AuthType Basic
AuthName "Protected Access"
AuthUserFile / var / www / yourname / . htpasswd
Require valid - user
< / Files >
Categories: How-To's , Technology Tags: apache , Auth , Authentication , AuthType , Basic , File , Files , howto , htpasswd , Protect , tips
| No comments
Author:
erics , July 19th, 2012
An HTML file input can’t be cleared by normal means (i.e. setting the value to null or an empty string) because of browser security restrictions. In most browsers, setting a null value attribute either will have no effect or cause an error. Creating a new element that clones the old element and swap the two […]
Categories: How-To's , Technology Tags: Clear , File , File Input , howto , html , input , tips
| No comments