SQL Database/Godaddy

bigdunc · 21 Feb 2018 at 20:57

We have had a website designed and had 2 files sent to us from the designer. One is a .bak file which I believe is an SQL backup file? and the other is a .zip file containing images and other data. I have looked on Godaddy website for help on getting it uploaded but am stuck so am wondering if anyone here could help?

I have created a blank SQL database in plesk but there is no option to import dump which is what all info on the web is telling me to do.

Any help appreciated

Cheers

AHarvey · 22 Feb 2018 at 08:40

Never used Plesk but a quick google shows: https://docs.plesk.com/en-US/12.5/c...exporting-and-importing-database-dumps.69538/

Does the GoDaddy hosting not just used CPanel and PHPMyAdmin?

Randomface74 · 22 Feb 2018 at 08:58

.bak is a database backup, you can restore it to Microsoft SQL Server in SQL Server Management Studio, doesn't sound like you have either...

touch · 22 Feb 2018 at 10:23

billysielu said:
.bak is a database backup, you can restore it to Microsoft SQL Server in SQL Server Management Studio, doesn't sound like you have either...

Management studio is a free download. He can just install it and connect it to his database.

Use the instructions under "Accessing Databases" in the link AHarvey posted above for info on how to connect management studio to your database.

Randomface74 · 22 Feb 2018 at 11:49

If you end up stuck, consider making a script to create schema and data.