I have a debian installation on a virtual machine with a btrfs filesystem at /dev/vda2. A subvolume named @ is mounted at / and @home is mounted at /home.

My aim is to do a clean reinstall of the OS while keeping the files in @home. The problem is that formatting the btrfs partition in the...

My notes on migrating a Drupal 7 site to Drupal 9.

1. Backup your MySQL database (use the database backup tool on the Zenphoto overview page for example).
2. Log into your existing site to be sure you know your Zenphoto user/password. Password recovery is not available during an upgrade!
3. Be sure to backup customized themes or plugins or any other cu...

Log into MySQL as root (assumes password is stored on /root/.my.cnf, otherwise you will have to enter a password):

  sudo -H mysql -p

Create a new database for your site:

  CREATE DATABASE databasename CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

Create the database user and grant privi...

SQL Query to Extract Bookmarks from Firefox places.sqlite Database

SELECT moz_bookmarks.id,moz_bookmarks.title,moz_places.url,description FROM moz_bookmarks INNER JOIN moz_places ON moz_bookmarks.fk = moz_places.id;