skip to Main Content

how I can convert a SQL file dumped from Plesk to excel or MySQL by software without installing SQL server management on windows?

2

Answers


  1. I found this for a MySQL import via Command Line, without SSMS:

      mysql -u username -p new_database < data-dump.sql
    

    here:

    https://www.digitalocean.com/community/tutorials/how-to-import-and-export-databases-in-mysql-or-mariadb

    Login or Signup to reply.
  2. In Plesk:

    1: Go to your DB page plesk DB page

    2: Hit phpMyAdmin

    In phpMyAdmin:

    1: Hit export phpMyAdmin nav bar

    2: Go down to where it say "Format" and change it to the format of your choosing enter image description here

    3: Click on "Go"

    Hope this helps,

    Ethan Lindsey

    Login or Signup to reply.
Please signup or login to give your own answer.
Back To Top
Search