Common jobs and where they are covered.
TAKING A BACKUP
cPanel > Backup > Partial Backups, or phpMyAdmin Export, or the command line for large databases.
RESTORING
Drop existing tables first, then import.
CHANGING A SITE URL
Two rows in the options table, or constants in the configuration file.
CHANGING A DOMAIN
A serialisation-aware search and replace, never a plain SQL replace.
RESETTING A PASSWORD
MD5 function in phpMyAdmin, or WP-CLI.
CLEANING BLOAT
A maintenance plugin, then optimise the tables.
FINDING SLOW QUERIES
A query monitoring plugin during a page load, then EXPLAIN.
FIXING A CRASHED TABLE
Repair in phpMyAdmin's Operations tab.
FINDING WHICH DATABASE A SITE USES
Read its configuration file.
RECOVERING ONE ROW
Import the backup into a temporary database and copy the row across.
BEFORE ALL OF THESE
Back up. SELECT before you write. Confirm which database is selected.
