Dump one table

bash

mysqldump -u root -p app_db users > users.sql

Explanation

Useful for debugging, selective migrations, or sharing one dataset slice.

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

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.