Login to the cPanel of your web server and open phpMyAdmin. Select the database that contains the WordPress installation from the list on the left sidebar and once selected click on the Export tab on the top navigation menu.
Another way of taking the backup is through the Backups section of your hosting.