Restore from a SQL dump

bash

mysql -u root -p app_db < app_db.sql

Explanation

This replays the SQL statements in the dump file against the target database.

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

Export rows without CREATE statements.

Open In sheetbashsame section

Import delimited files efficiently.

Open In sheetsql1 tag match

Restore a dump created by MySQL Shell utilities.

Open In sheetbash1 tag match