Installing systm backup from different domain fails

[cibalibeb]

I have made a backup copy of my existing installation and want to import that backup onto another installation on a separate domain for some testing functions. I have already uploaded all the files from the "code" folder from the backup, however when I log into my new installation 1.2.1 and I choose restore, I select the .php file and click restore I get a spinning wheel for a few minutes and then an error, I have attached a screenshot of the error and the log

[Basara]

... I log into my new installation 1.2.1 and I choose restore, I select the .php file and click restore I get a spinning wheel for a few minutes and then an error, I have attached a screenshot of the error and the log

When restore in admin select .sql file from DATA folder
http://docs.abantecart.com/pages/tips/change_domain.html#ChangeHosting

[cibalibeb]

Sorry I meant the .SQL file not the .PHP I have attached a screenshot of the file I was trying to upload

[Basara]

Make sure your new installation have same database prefix (in your case x0h_  )

[cibalibeb]

Is that so the new installation can access the old database? Also how do I modify the new install to change where it looks for the database?

[Basara]

install new AbanteCart with normal process on the new host (do not load demo data)
NOTE: You need to select the same MySQL database prefix as on your current AbanteCart instance

[cibalibeb]

I am using softaculous to install, siteground is my hosting. I have attached a screenshot of the install page options, and do not see an option not to load the demo data If the demo data is loaded will this mess up my current database?