Dump / backup

CautionBack up a DB

pg_dump / mysqldump

Takes a logical backup — insurance before changes.

Examples

mysqldump -u root -p appdb > appdb.sqlDump a MySQL database

Syntax

pg_dump <db> > out.sql | mysqldump <db> > out.sql

Before you run it

Large DBs are slow/heavy and may lock.

Used when you see

Back up / restore

Back up databasesInsurance before changes

See the whole flow →

Related commands

Connect (psql/mysql/sqlcmd)Connect to a DB

The same reference, with no signal at all

Every command on this site, held on your device. The app adds 632 more: 1,510 commands and 120 fix flows, searchable with no connection. Free to install, no ads (some content is a one-time purchase).

Get it free on the App Store