Cheat Sheet logoCheat Sheet Today
MySQL Backup, Restore, Import, and Export Cheatsheet/Dump one database

Export schema and data from one database.

Back to sheetBrowse commands
Sign in to save
Section: mysqldump and restore

Dump one database

bash
bash
mysqldump -u root -p --databases app_db > app_db.sql
Explanation

A standard logical backup command for development, migration, and restore workflows.

View in sheet →

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Compare commandsView fixes

Related commands

Same sheet · prioritizing mysqldump and restore
Dump one table
Export a single table only.
OpenIn sheetbashsame section
Dump schema only
Export DDL without row data.
OpenIn sheetbashsame section
Dump data only
Export rows without CREATE statements.
OpenIn sheetbashsame section
Restore from a SQL dump
Load a dump file into MySQL.
OpenIn sheetbashsame section
Dump an instance with MySQL Shell
Use MySQL Shell utilities for scalable dumps.
OpenIn sheetbash1 tag match
Export query results to CSV-like output
Write rows to a server-side file.
OpenIn sheetsql