how I can convert a SQL file dumped from Plesk to excel or MySQL by software without installing SQL server management on windows?
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
I found this for a MySQL import via Command Line, without SSMS:
here:
https://www.digitalocean.com/community/tutorials/how-to-import-and-export-databases-in-mysql-or-mariadb
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