Thursday, November 23, 2017

Create bootable USB from .iso file - Linux

Plug-in USB drive into your computer. Open up terminal and type :

fdisk -l

You'll see listing of drives available on your computer. Normally the USB drive will be shown like this :

/dev/sdb1 or /dev/sdc1

Now run this command:

sudo umount /dev/sd<?><?>

where first question mark is letter and second question mark is number. Then run this command:

sudo dd bs=4M if=the_image_file.iso of=/dev/sd<?><?>

Wait until finish and run command sync

Done!

Friday, January 27, 2017

ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement

I ran this command:

LOAD DATA INFILE '/root/tk_worker_latestjan17.csv' INTO TABLE tk_worker_temp FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 ROWS;

I got the following error:

ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement

Solution:

  1. Run this command  SHOW VARIABLES LIKE "secure_file_priv"; to show the configured directory.
  2. Move the file to the directory specified by secure-file-priv 

Thank you