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
Related commands
- Connect (psql/mysql/sqlcmd)Connect to a DB
The same reference, with no signal at all
Every command and flow from this site, held on your device and searchable with no connection. Free to install, no ads.
Get it free on the App Store