Latest posts
98 articles
La Quadrature Joins the Legal Struggle Against Mass Surveillance
La Quadrature du Net joins the legal struggle against mass surveillance. Most so-called democratic western governments are trying to legalise massive surveillance under the pretence of fighting terrorism and child abuse.
Delete lines containing a specific string with sed
The following command makes sed delete every lines containing the matching pattern from the file named foo. If this file is important, we make sure to back it up first! $ sed -i '/pattern/d' /path/to/foo The -i flag (GNU version only) edit the file in-place. For non-GNU version, we can redirect the…
Avaaz petition to protect Sumatra's rainforest and its orangutans
Help protect Sumatra's rainforest and its orangutans by sending a message to ambassador Olof Skoog.
MariaDB / MySQL: export or backup data to a CSV file
It seems there are several ways to do this. Here is one, using the mysql prompt. I used mysql root account because my usual user has not enough permissions to write files (ERROR 1045 (28000): Access denied for user 'username'@'localhost' (using password: YES)), even after a chmod 777: UPDATE: We…
MariaDB / MySQL: backup and restore a specific table
We just have to specify the name of the table we want to backup in the usual mysqldump command: $ mysqldump -h hostname -u username -p database_name table_name > backup_table_name.sql Then, to restore it: Source