MySQL provides a great command line utility to take backups of your MySQL database. mysqldump command line utility is available with MySQL installation (bin directory) and can be used to achieve this.
Login to your server with root user
Use following command for taking backup of your MySQL database using mysqldump utility.
mysqldump –u[user name] –p[password] [database name] > [dump file]
Now to make sure the command was executed and the backup file was created using the command
on the same path and you should see the database backup file.