Category: How to ?

Install iso on USB key using #Linux console only

How to flash any iso (think about your favorite distro) on an USB key without graphical IHM ? sudo dd if=/path/to/image.iso of=/dev/sda1 status=progress oflag=sync “/path/to/image.iso” is the path to the ISO file /dev/sda1 is your USB key device (see below to get yours) status=progress show flashing progression oflag=sync to synchronize write access on the USB

Continue Reading →

MySQL import from csv

To import a local CSV file into MySQL, use the syntax below : LOAD DATA LOW_PRIORITY LOCAL INFILE ‘/path/tofile.csv’ INTO TABLE database.table FIELDS TERMINATED BY ‘;’ OPTIONALLY ENCLOSED BY ‘”‘ ESCAPED BY ‘”‘ LINES TERMINATED BY ‘\n’ IGNORE 1 LINES (`field1`,`field2`,…)

Continue Reading →

MySQL export to csv

To export a mysql results in CSV format, use the syntax below : SELECT field1, field2, … FROM table WHERE condition INTO OUTFILE ‘/tmp/toto.csv’ FIELDS TERMINATED BY ‘;’ ENCLOSED BY ‘”‘ LINES TERMINATED BY ‘\n’ ;

Continue Reading →

Cheyenne server and POST size limit

By default, in Cheyenne, the header size limit for a post request is 102’400. If you want to ajust this limit you can define the post-mem-limit parameter in the global context or in a specific webapp. For example, to double the initial limit in the httpd.cfg, : … default [ root-dir %./www/ default [%index.html %index.rsp]

Continue Reading →