H2 database control: Difference between revisions
Jump to navigation
Jump to search
Content deleted Content added
imported>Kymara No edit summary |
imported>Kymara No edit summary |
||
| Line 1: | Line 1: | ||
== |
== Connecting to the H2 Database == |
||
Make sure the game server is '''not running''' (using '''CTRL+c''' at the server command window). Otherwise you'll get this error later: |
Make sure the game server is '''not running''' (using '''CTRL+c''' at the server command window). Otherwise you'll get this error later: |
||
| Line 13: | Line 13: | ||
[[File:H2dbGuide002.png]] |
[[File:H2dbGuide002.png]] |
||
Alternatively, you can see it with any other web browser by entering the following URL: |
'''Alternatively,''' you can see it with any other web browser by entering the following URL: |
||
http://localhost:8082/ |
http://localhost:8082/ |
||
===Configuration parameters=== |
|||
At the ''URL JDBC:'' text field, copy and paste this: |
At the ''URL JDBC:'' text field, copy and paste this: |
||
| Line 35: | Line 35: | ||
Now you should have been given access to the game database. |
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: |
For starters, you can see the accounts in the database by clicking on the ACCOUNT table name on the left graphical tree: |
||
| Line 53: | Line 54: | ||
Feel free to experiment from here on. :) Anything other than a SELECT should be used with caution on production environments! |
Feel free to experiment from here on. :) Anything other than a SELECT should be used with caution on production environments! |
||
| ⚫ | |||
== 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. |
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' |
|||