LiveChat 
Support 
Backup Database from PHPMyAdmin
You are able to backup databases in different variety of ways, one in all that is via the Backup Facility with cPanel however there are different alternatives to Backup MySQL databases without the requirement of that facility on its own. you’ll backup via phpMyAdmin within the Export section of the facility. Rather like the backup facility in cPanel, it will provide backups to you as a .tar.gz format which suggests you’ll be ready to restore it via the cPanel facility if you would like to try to do so.
• Once you’ve accessed the phpMyAdmin facility enter into the database (empty or otherwise) and from the top menu click Export.
• Scroll down on page till you get to a ‘Save as file’ option and choose ‘gzipped’ and leave the settings as default.
• Click ‘Go’
To restore via the phpMyAdmin facility unfortunately you’ll already required the database setup to restore the inner contents, like the tables, etc. thus create a rnew database (name it as equivalent because the database name that you backed up previously). Once you’ve created the database and you’re within it, from the top menu again click Import.
• Now choose ‘Browse’ and search the relevant gzipped file, and leave all settings as default.
If all goes well you will see the contents of the database all there. keep in mind rather like the cPanel backup facility, if you use usernames for every database you’ll required to set that up separately, for example if you restored the backup via the cPanel facility. Ensure you re-connect the username and database along.