Author Archives: Brahim

Don’t forget master infos in your MySQL dump

I tried to resync a slave MySQL after it disconnected from the master. But the binary log was already deleted on master, so the only solution was to restore from the last backup. To avoid lock tables on the master and remember the binary log name and position to put them on the slave configuration, there is a tip to take care of all that : the “–master-data” option in mysqldump. Continue reading

Red Programming Language: Eve-style clock demo in Red, livecoded!

Red is a next-gen programming language, strongly inspired by REBOL. Main features are:

  • Homoiconic (Red is its own meta-language and own data-format)
  • Functional, imperative, reactive and symbolic programming
  • Prototype-based object support
  • Gradual and multi-typing
  • Macros system
  • Rich set of built-in datatypes (50+)
  • Both statically and JITcompiled to native code
  • Cross-compilation done right.
  • Produces executables of less than 1MB, with no dependencies.
  • Concurrency and parallelism strong support (actors, parallel collections)
  • Low-level system programming abilities through the built-in Red/System DSL
  • Powerful PEG parser DSL
  • Cross-platform native GUI system, with a UI DSL and drawing DSL.
  • Bridging to the JVM
  • High-level scripting and REPL console included
  • Highly embeddable
  • Low memory footprint, garbage collected
  • Single-file (~1MB) contains whole toolchain, standard library and REPL.
  • No install, no setup
  • Fun guaranteed. 😉

Source : Red Programming Language: Eve-style clock demo in Red, livecoded!

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`,...)

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' ;

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]
	post-mem-limit 408'800
]
...