How to backup a MySQL database

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 🙂

David Burgos

Read more posts by this author.