DB Navigator. Execute SQL script.


PHPStorm, OS X, EI Capitan.

Error log below. But, if the "Executing command" is executed independently in the OS terminal, the SQL script is executed successfully.

DB Execution Console (logs):

https://account.jetbrains.com/reset-password/2q8rx0v97efjh0911439ch4pz17 нояб. 2019 г., 17:17:47: Connection / <name>.sql - Initializing script execution
Creating temporary script file /var/folders/5j/b5mhdx0936j2z_4h9x_lhmhr0000gn/T/DBN-10607173353769764311.sql
Executing command: /Applications/XAMPP/xamppfiles/bin/mysql --force --verbose --host=localhost --port=3306 --database=XXXXX --user=XXXX --password=XXXXX -e "source /var/folders/5j/b5mhdx0936j2z_4h9x_lhmhr0000gn/T/DBN-10607173353769764311.sql"

17 нояб. 2019 г., 17:17:47: Connection / <name>.sql - Script execution started
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '"source /var/folders/5j/b5mhdx0936j2z_4h9x_lhmhr0000gn/T/DBN-1060717335376976431' at line 1
"source /var/folders/5j/b5mhdx0936j2z_4h9x_lhmhr0000gn/T/DBN-10607173353769764311.sql"

Deleting temporary script file /var/folders/5j/b5mhdx0936j2z_4h9x_lhmhr0000gn/T/DBN-10607173353769764311.sql

1 comment

It appears to be this one: https://youtrack.jetbrains.com/issue/DBE-7048
I've added your case details to the thread. Sorry for the inconvenience!


Please sign in to leave a comment.