Backup & restore database on local

At times, you'll need to backup and restore your local database. This guide will walk you through the process.

Backup

Here's how to dump your local database with Docker into a .sql file

docker exec db_dodwpstarterkit /usr/bin/mysqldump -u wordpress --no-tablespaces --password=wordpress wordpress > backup.sql

Restore

Restore a previous database backup

cat backup.sql | docker exec -i db_dodwpstarterkit /usr/bin/mysql -u wordpress --password=wordpress wordpress