by christian | Sep 3, 2014 | Work |
If it doesn’t already exists, create the file .my.cnf in your home directory. Add the following to it, replacing db_username and db_password with the database username and password. make sure the file permissions are set to 600 (chmod 600 .my.cnf) so it is...
by christian | Nov 26, 2013 | Work |
This is one of those things that drives me mad, that I can never find in the documentation. I’m currently running Gnucash 2.4.11 on Mint 14 (based on Ubuntu) and sometimes need to edit the invoice template. I can never find where the damn thing is. Currently,...
by christian | Sep 5, 2013 | Work |
This is one of those things I often forget to do when setting up WordPress on a new server, which means pretty permalinks don’t work: If you have a problem with permalinks not working on WordPress, it may be because Apache does not have mod_rewrite enabled. An...
by christian | Jul 30, 2013 | Work |
To Restart Apache on Ubuntu or Mint (and possibly more): $ sudo service apache2 restart
by christian | Jan 24, 2013 | Work |
When debugging applications, it can be useful to see what’s going on in the database without referring to the code. In MySQL, you can use the information_schema database to get this information. here’s what I do: Select table_name, table_rows, update_time...
by christian | Dec 21, 2011 | Work |
I mainly use nawk to extract elements from a string where I know the position (eg to get just the filenames when running a grep and I’m just too lazy to remember the correct grep syntax). so, to extract field number x from strings in where the field separator...