Backups and Restorations

Backing Up a Database

mysqldump -u root -p my_database > backup.sql

This command creates a backup of my_database.

Restoring a Database

mysql -u root -p my_database < backup.sql

Restores the database from backup.sql.