How to setup a new installation using a website backup from Hostgator

[NooseLadder]

I have a backup file from an old hosting account with Hostgator. I have had to set up a new hosting account and they have sent me a backup file from the old account. The old account no longer exists.

All I have to work with is a brand new installation of the latest processwire 2.7.7 and a website backup from an old Hoatgator account supplied by Hostgator Technical team.

How do I get the backup from Hostgator into the new Processwire installation?

In the backup folder:

The site folder structure is in a folder called public_html.

There is a folder called mysql containg two files with the name of the old database:

OldDatabaseName.sql

OldDataBaseName.create

I have installed the new version of processwire and this is as far as I have got.

Any help will be appreciated.

[elabx]

What I commonly do:

You have to import the .sql file data into a new database, you can do this through phpMyAdmin.

Copy the Processwire backup files into your public_html (don't forget the sneaky .htaccess in the PW installation root, it is commonly hidden), and edit site/config.php and edit your database data:

$config->dbHost = 'localhost';
$config->dbName = 'dbname';
$config->dbUser = 'dbuser';
$config->dbPass = 'verydifficultpassword';
$config->dbPort = '3306';

If everything goes ok, it should work!

[NooseLadder]

Thank you so much.I finally got this to work. I had to delete some lines from the sql file as it kept forcing an error, such a screat database, as it was already created and something about  a module called ProcessRedirests. But it finally worked,thanks.