Dump schema only

bash

mysqldump -u root -p --no-data app_db > app_db-schema.sql

Explanation

Common when you want table definitions for code review or environment bootstrapping.

Learn the surrounding workflow

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

Same sheet · prioritizing mysqldump and restore

Export schema and data from one database.

Open In sheetbashsame section

Export a single table only.

Open In sheetbashsame section

Export rows without CREATE statements.

Open In sheetbashsame section

Load a dump file into MySQL.

Open In sheetbashsame section

Write rows to a server-side file.

Import delimited files efficiently.