mysql -u root -p myapp_db < backup.sql

Category: Self-Hosting

mysql -u root -p myapp_db < backup.sql

Restore a MySQL database from a SQL dump file

Restores a MySQL database from a dump file. Create the database first with 'CREATE DATABASE myapp_db;'.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.