Recently I moved this blog to Vultr, so I needed remind how to backup a MySQL database. Follow reading to find out how:
Backup a MySQL database
Just login to your MySQL server and run this command:
mysqldump -u mysqlUsername -p databaseName > backup.sql
Please note to change your mysqlUsername
, databaseName
and backupFile
to your case.
The system will prompt you the password, just type and press ENTER
. The password will not be shown while you entering it.
Feel free to leave your doubts or experiences 🙂