1

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

jarlh
  • 42,561
  • 8
  • 45
  • 63
Mehdi Yaghoubi
  • 561
  • 3
  • 8
  • 24
  • Does this answer your question? [How do I import an SQL file using the command line in MySQL?](https://stackoverflow.com/questions/17666249/how-do-i-import-an-sql-file-using-the-command-line-in-mysql) – anestv Dec 15 '21 at 20:38

2 Answers2

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

Thunk
  • 11
  • 2
0

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

Ethan Lindsey
  • 39
  • 8