Click on ‘Import File’ to import a single file, or click on Import Directory’ to import all the files in a folder. The restoring process might end with an error, just click cancel and do not click Ok to restore again. To import hands from Holdem Manager 2 Hand Archive, follow the instructions below: Step 1. Leave all the default settings as is and click OK.ĩ. button and go to the location where the backup file is located and click Open.Ĩ. In pgAdmin III, xpand the Databases folder and select the new database, right click and select restore. In the Properties tab, enter a new name and leave everything else as default. In pgAdmin, click on Edit > New Object > New Database. Upon successful authentication, you will see the properties populate as shown in the screenshot below:Ĥ.
HOLDEM MANAGER 2 DATABASE PASSWORD
This is your password that you used when setting up PostgreSQL. In your desktop, navigate to Start > All Programs > PostgreSQL 8.x > pgAdmin III.ģ. To restore your database, do the followingġ. It also must be a completely empty database, trying to restore to an old database or a database created via Holdem Manager will corrupt the old database and cause duplication of hands. Note: Its extremely important that you only restore a database to a blank database created via the method below. The selected database has now been backed up. You will know it's finished when the OK button, which is grayed out during backing up, changes to Done. While it's backing up, it may become unresponsive. The selected database will now begin backing up. Remember the location as this is where you'll need to restore it from. Note: Leave all the default settings as they are. Note: Click on Browse Folders to select a location. In the Filename field, click on the ellipsis button and choose a name and location where you want to save it to. Right click on the database you selected and choose Backup. Note: You may see a popup window about database encoding and if so, click on don’t show this tip again and click on OK.ĥ. Expand the Databases folder and select the applicable database (HoldemManager by default). Upon successful authentication, you will see the properties tab populate as shown in the screenshot below:Ĥ. Double click on PostgreSQL Database Server 8.x in the object browser field. Similarly, you can navigate to C:\Program Files\PostgreSQL\8.x\bin\ and clicking on the elephant icon called pgAdmin3.exe.Ģ.
HOLDEM MANAGER 2 DATABASE INSTALL
Note: To increase the chance of this working, make sure you install the same version of PostgreSQL that housed your old database. Note: Before backing up and restoring a Database, backup your current Hand History files as a safeguard! If you've been archiving your Hand Histories they should be easily accessible if not, Export your Hand Histories from your current Database first so you always have a backup.
HOLDEM MANAGER 2 DATABASE PC
Note: This FAQ is intended for Advanced PC Users Only!!!
How do I backup and Restore my HM1 Database? (Try our new Backup/Restore utility.