How to quickly back up and restore a database with phpMyAdmin ... sql backup file you downloaded from the export. Restoring a MySQL database using the phpMyAdmin import tool.

I’m going to assume your website depends on a MySQL database, runs on Apache, and /var/www/html is your document root. To make this backup/restore happen, you’ll need a user with root privileges.