H2 database control: Difference between revisions
Content deleted Content added
imported>Jtsmith No edit summary |
imported>AntumDeluge →Connecting to the H2 Database: side-by-side connections |
||
| (24 intermediate revisions by 3 users not shown) | |||
Line 1:
==
<del>
Make sure the game server is '''not running''' (using '''CTRL+c''' at the server command window). Otherwise you'll get this error later:
[[File:H2dbGuide001.png]]
</del>
In order to access the database while server is running, "AUTO_SERVER=TRUE" must be added to the "jdbc_url" line in <code>server.ini</code>.
Open a command window as explained above.
Line 13 ⟶ 17:
[[File:H2dbGuide002.png]]
'''Alternatively,''' you can see it with any other web browser by entering the following URL:
http://localhost:8082/
Don't connect yet as you need to set the ...
===Configuration parameters===
At the ''URL JDBC:'' text field, copy and paste this:
Line 35 ⟶ 42:
Now you should have been given access to the game database.
==Exploring the H2 database==
For starters, you can see the accounts in the database by clicking on the ACCOUNT table name on the left graphical tree:
Line 51 ⟶ 59:
[[File:H2dbGuide009.png]]
Feel free to experiment from here on. :) Anything other than a SELECT should be used with caution on production environments!
For a list of H2 commands see http://www.h2database.com/html/grammar.html
== Stop the H2 database ==
To stop the database engine use the same method as with the game server: type '''CTRL+c''' at the command window.
== Backup the H2 database ==
You can copy the files in ~/stendhal/database but the server must be '''stopped'''.
Otherwise from within the h2 environment, as above, use command
BACKUP to 'file.zip'
| |||