Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Where does IntelliJ IDEA store database console scripts?

I couldn't find answer to this questions on SO despite long search. For some reason I thought I've seen it before.

Do you guys know in which file IDEA saves content of database console scripts ?

I thought it was in dataSources.ids but I don't see scripts there, only connection settings.

like image 402
expert Avatar asked Sep 16 '13 02:09

expert


People also ask

Where does IntelliJ store Database?

By default,IntelliJ IDEA stores your projects under ~\DataGripProjects.

Where is data source in IntelliJ?

To access the Data Sources and Drivers dialog ( Shift+Enter ), perform one of the following actions: In the Database tool window (View | Tool Windows | Database), click the Data Source Properties button. . In the Database tool window (View | Tool Windows | Database), click the Add button.

How do I get SQL file in IntelliJ?

In the Project tool window (View | Tool Windows | Project), right-click the directory in which you want to create an SQL file and select File. In the New File dialog, specify the filename with the SQL extension.

Where is the console in IntelliJ?

Click a data source and select File | New | Query Console. Right-click a data source and select New | Query Console. Click a data source, press Alt+Insert , and select Query Console. Click a data source, press Ctrl+Shift+F10 , and select New Query Console.


1 Answers

Try looking into the IntelliJ cache folder.

For me I did not find the database scripts themselves, but found a history of all the sql statements executed here :

`c:\Users\$user\.IntelliJIdea13\system\userHistory\*.xml`

(Am on IntelliJ Idea EAP).

like image 65
Ashutosh Jindal Avatar answered Sep 17 '22 18:09

Ashutosh Jindal