MySQL 8.4 · Backup and restore

Back up every database

Write one SQL dump containing all databases.

mysqldump -u root -p --single-transaction --all-databases > all.sql

Official MySQL 8.4 documentation

More backup and restore commands

All backup and restore commands · MySQL 8.4 cheatsheet

Was this page helpful?