mysqldump -u root -p myapp_db > backup.sql

Category: Self-Hosting

mysqldump -u root -p myapp_db > backup.sql

Export a MySQL database to a SQL file for backup

Exports a MySQL database to a SQL file. Schedule this in cron for automated backups.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.