If you want to take the backup of a database, follow these steps
1) Login to your server
2) Execute the command
mysqldump -u username -p password databasename > databasename.sql
where username is the mysql user of that database
password is the password for that user
databasename is the database which we want to backup.
databasename.sql is the name of the backup file or dump file.
Creates the backup file of the database to the current working directory.
