H2 database control: Difference between revisions
Content deleted Content added
imported>Blacklads Undo revision 11683 by Ufizavipupu (Talk) |
imported>AntumDeluge →Connecting to the H2 Database: side-by-side connections |
||
| (33 intermediate revisions by 4 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 22 ⟶ 29:
[[File:H2dbGuide003.png]]
Note (if your server files are not in ~/stendhal): By default, the server.ini configuration file defines the H2 database directory as "~/stendhal/database/". Unless, you have edited the server.ini file, this is where your database resides regardless of from what directory you are running the server.
Make sure the ''Username'' and ''Password'' fields are empty:
Line 33 ⟶ 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 49 ⟶ 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'
| |||