Homemade sushi

Preparing sushi at home is not so difficult as you may think.

Sushi 1

Sushi 2

Sushi 3

To learn more about sushi read the page on Wikipedia and Rolling Your Own Sushi written by Mark S. Hutchenreuther.

Some tips for Italians:

  • If you can’t find Japanese rice (it has nothing in common with basmati!) use vialone nano.
  • Nori (the seaweed used to roll the sushi) is not easy to find in small towns. I buy it from Esselunga stores.
  • If you can’t find rice vinegar use apple or even white wine vinegar.

WordPress backup

I want to do an automatic weekly backup of the blogs hosted on my server. The scripts I found require you to specify the database name, the user name and the password in the script. However this is not an option because I want to do the backups without modifying the script when I add or delete a blog.

The default wp-config.php in Debian searches for a configuration file based on the blog’s host, so you can host more than one blog on the same system. These cofiguration files have the following format:

define('DB_NAME', 'xxx');
define('DB_USER', 'xxx');
define('DB_PASSWORD', 'xxx');
define('DB_HOST', 'localhost');

$table_prefix  = 'wp_';

$server = DB_HOST;
$loginsql = DB_USER;
$passsql = DB_PASSWORD;
$base = DB_NAME;

My script extracts the needed parameters from the configuration files and dump the database to a gzipped backup file.

#! /bin/sh

# Backup directory
dir=wp-backup-`LC_ALL=C date +%d%b%y-%H.%M`

mkdir $dir

# Set the variable in $2 to the value read from the
# config-*.php file passed in $1.
function getval() {
    eval $2=`grep "'$2'"  $dir/$bak_file

Note that the script saves every table in the database. If you have any statistics or anti-spam plugins they could generate some big tables you may want to skip. To do this pass to mysqldump, after the database name, the tables you want to save. AFAIK for WordPress 2 these are: wp_categories, wp_comments, wp_linkcategories, wp_links, wp_options, wp_post2cat, wp_postmeta, wp_posts, wp_usermeta, wp_users.