Initialize the database

BlogLoom stores business data in MySQL. Initialization runs through bin/local/upgrate-sql.sh; manually importing init.sql is no longer required.

1. Create the database

CREATE DATABASE blogloom
  CHARACTER SET utf8mb4
  COLLATE utf8mb4_unicode_ci;

The script verifies that the database exists before running, so create it first.

Copy the template on first use:

cp bin/local/deploy.conf.example bin/local/deploy.conf

Edit bin/local/deploy.conf:

Setting	Description
`DB_HOST` / `DB_PORT`	MySQL host and port
`DB_USER` / `DB_PASSWORD`	Database user and password
`DB_NAME`	Database name, default `blogloom`

A custom config file can be used as well:

LOCAL_UPGRADE_CONFIG=/path/to/deploy.conf bin/local/upgrate-sql.sh

Preview the pending scripts, then run:

bin/local/upgrate-sql.sh --dry-run   # list pending SQL only, no DB connection
bin/local/upgrate-sql.sh             # execute and record

Script behavior:

Pending: sql/increment/<version>/**/*.sql, sorted by filename (timestamp);
Recorded: on success, a copy is written to the flat sql/local/ directory;
Idempotent: files already recorded in sql/local/ are skipped, so reruns are safe;
Failure keeps context: working files and logs are kept in sql/local/.work/ on failure.