This article is for cases when you do not have a backup of your files, and only a database backup is available. If you have both website files and database backup, it's highly recommended to restore your website the regular way.

This method of recovery is only partial, and you might not be able to recover everything. However, WordPress stores most settings and data in its database. Thus, you will be able to recover most of your WordPress website only from your database.

First, open your Websites → Manage, search for Databases Management on the sidebar and click on it:

And create a database. Then, open it in phpMyAdmin, and import the database backup file.

NOTE:

Since you only have a MySQL database at the moment, the next step should be installing a fresh WordPress. For that, download the WordPress installation files from the official website, and upload them with any suitable option (Import Website, File Manager, FTP).

Access your WordPress admin area (open domain.tld/wp-admin, where domain.tld is your domain), choose the language for your website, and click Let's go!

In the next step, you are required to provide the database details. Insert the data from the database you created in the previous step:

If everything was done correctly, you will get a message indicating that WordPress is already installed:

Now you can log in using your old credentials.

NOTE:

At this point, your website should have your old posts and pages, settings, custom CSS files, and users. For it all to display properly, you need to reinstall your theme and plugins.

For the theme, install your previous theme.

Then, open the Plugins menu and install the missing plugins. If you don't remember the full list of plugins, don't worry - the database has records of all of them, so you will see a warning about each plugin that is missing:

In the next step, you need to recreate the permalinks. After this, most links on your website should work properly.

As databases don't contain images, you will need to re-upload each image. To ease this process, we will use two tools:

Install and activate a Broken Link Checker plugin. Then, open its settings (will most likely be at Tools → Broken Links, but may differ based on your WordPress and plugin versions). There you will see a full list of broken links - it will help you determine which images are missing and their previous location. All you need to do is re-upload these images:

In case you don't have all or some of the images, you can get them from the Internet Archive if your website was indexed. For that, insert your website address into the WayBackMachine section:

If there are any snapshots available for your website, you will see these blue circles around certain dates of the year. Click on those dates in order to access a previous version of your website:

After that, search for the specific images that are missing, download them from the archived version, and upload them back to your website.

That's it, now your website should be restored 🎉