Plesk Question posted in
The official documentation for Plesk Obsidian can be found here.

How to import MSSQL database dump from Plesk into local MS SQL server?

I have a plesk account and an MS SQL database from which I got a dump through this interface they provide:

enter image description here

So I downloaded the dump file but it does not come as a .txt file but it comes without any extension and when I try to import it in my local MS SQL Server it fails always.

enter image description here

And when I try to open the dump file with notepad it shows weird characters(see picture below).

What am I doing wrong?

enter image description here

Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0

    I finally found my way using a php script found on github I had to fork it to update couple things cause it became obsolete.

    I had to go this way for couple reasons:

    • I didn't have admin access to the plesk server to enable remote DB access
    • I wasn't able to export it into any format readable by mysql

    So with the php script i could load it unto the server and run it, The script copies an MSSQL into MySQL. Here is my fork.


  2. 0

    I got it to work by extracting the dump file from the zip and renaming it with a .bak extension. Then did a Database restore in MS SQL Management Studio and selected this backup file (.bak). Hope that helps.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search