Skip to content
Notas

Dump & Restore MySQL

Use root user.

Dump database

https://dev.mysql.com/doc/mysql-backup-excerpt/8.0/en/mysqldump-sql-format.html

Terminal window
mysqldump -h 127.0.0.1 --port=3306 -u MY_ROOT_USER_NAME -p MY_DATABASE > backup.sql
  • —password= MY_ROOT_USER_PASSWORD

Restore database

https://dev.mysql.com/doc/mysql-backup-excerpt/8.0/en/reloading-sql-format-dumps.html

Terminal window
mysql -h 127.0.0.1 --port=3306 -u MY_ROOT_USER_NAME -p MY_DATABASE < backup.sql