View Full Version : Database

10-22-2009, 04:01 PM
I want to replace my operating system and after this, reinstalling HM from scratch but i dont want to lose my database. Where can I find it and how to secure it?

I'll appreciate reply because im on hurry :)

10-22-2009, 04:14 PM
Before you uninstall HM:

I want to re-install Holdem Manger without losing all of my settings and preferences. Can this be done? - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=98

You want to make sure you backup your Processed/Archived hand histories, your entire \config folder, and your exportednotes file. http://www.holdemmanager.net/faq/?f=119. I usually just copy my entire \Holdem Manager directory.

Make sure you export your tournament summaries: Tourney > Results > Dataview > All Hands > Right-Click > Export Tourney Results and Summaries.

I would also make sure you manually export the database to hand history text files:

HM > Options > Database Management > Connect > Export Hands

How do I export or import hands into and from Holdem Manager? - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=173

Make sure you copy that folder as well as the other stuff I mentioned.

This helps to insure that if anything goes wrong with the backup/restore, you can manually import the exported files to rebuild.

Once all that is backed up, you can also create a .backup file to try a restore, on the new OS. If the restore doesnt work properly you will have to reimport the archived/exported hands.


For the new install:

If you have Vista/w7, please verify that UAC is still off. - http://www.holdemmanager.net/faq/afmmain.aspx?faqid=73. If it is on, please turn it off and reboot.

Turn off Windows Firewall for installing HM and PostgreSQL. You must also add exceptions to the Windows firewall, even if it is off. If you have a 3rd party firewall, uninstall it completely before installing HM/SQL - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=171

* Install the complete setup of HM: http://www.holdemmanager.com/downloads/holdemmanager.zip
* Download the latest patch HM: http://www.holdemmanager.com/downloads/HmBetaUpdate.exe

* Install PostgreSQL 8.4, with your firewall uninstalled or turned off if windows firewall - http://www.enterprisedb.com/products/pgdownload.do#windows

If you are restoring a DB you have to install the same version of postgresql you used for the old db, and follow the instructions I linked above.

Start Holdem Manager and connect/create a new UTF DB.

Search the FAQ for the setup guide for your poker site: