Latest posts
92 articles
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
Less than 20 days to help fund the Gooseberry project from the Blender Foundation
Update: having more than 3000 supporters, the team has decided to extend the campaign until May 8th. It is not too late to join in! Less than 20 days to help fund the Gooseberry project from the Blender Foundation. Blender is a free (as in freedom and free beer) 3D modelling software. After several…