View Full Version : quickest way to create a new DB for HM
i think i murdered my DB with a vacuum / analyze (by cancelling it midway... not clever i know)... anyways no biggie, but if i start HM now it freezes when it tries to connect to the DB, how can i create a new one without getting to the database management option?
morny
01-29-2009, 02:24 PM
You can go to C:\Program Files\RVG Software\Holdem Manager then open the Database Control Panel exe file and from there you can create a new database from there without using the old database
eh just realized a minor problem, i havent backed up my notes in 2009, what are my chances at getting to those if i cant even connect to the DB right now? how could i go about that?
morny
01-29-2009, 02:38 PM
The notes are stored within that database on postgreSQL so youll need access to the database im afraid which looks very unlikley given your problem
any ways of repairing a corrupted dbases? i see options for reindexing it in pgadmin III, but i dont want to try anything without a clue of what im doing... :)
morny
01-29-2009, 02:48 PM
Im far from an expert in PostgreSQL and it may be possible if you want to try and visit the PostgreSQL forums they may be able to help but from my understanding of what Roy has said there isnt much you can do unless its just the indexes that are damaged and in that case you usually get a message saying:
The following error occured: ERROR XX002: Index "playerhandscashnmisc_idx1" is not a Btree
Your not even able to load it and since interrupting database processes by closing in the middle of a procedure is one of the main causes of corrupting a database then it dosent look good.
mksmipalla
01-29-2009, 03:52 PM
The notes are stored within that database on postgreSQL so youll need access to the database im afraid which looks very unlikley given your problem
So what is the best way to back up our notes. I backup my confg file whenever I make a hud change are the notes also in that file or should I use the export notes tab then just move that folder to my backup folder?
morny
01-29-2009, 04:04 PM
Yeah export the notes Hud Options > Notes > Export Notes and keep them in a backup folder
mksmipalla
01-29-2009, 05:31 PM
Ok thanks.
quick follow up, i reran the vacuum / analyze over my corrupted dbase and behold... 27h later i was able to connect to it again and was able to salvage my notes, thx for the tip with the db control panel, really helped in the meantime.
really minor bug, all players that i just color coded (I.e. only changed the icon and didn't take and actual note) seem to have a note with a one digit number after exporting them and reimporting them to a new database.
http://img104.imageshack.us/img104/1949/notesdr9.jpg
running on 1.08 beta 6
in the exportednotes.hmnotes file the player is listed as
----PLAYER NOTE----
XXXXXX~|~10~|~6
~|~4
----PLAYER NOTE----
Powered by vBulletin® Version 4.2.3 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.