Dump data only

bash

mysqldump -u root -p --no-create-info app_db > app_db-data.sql

Explanation

Handy when the schema already exists and you only need data.

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 DDL without row data.

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.