Database Manager has the following options:

• Database Info
• Backup
• Restore
• Maintenance
• Import HM1 Databases
• Export Hands
• Purge Hands
• HM Sync

---

Database Info 

Green Plus = Create a Database
Blue Check = Make Selected Databse Active
Red Minus = Delete Selected Database

Database Status window shows:

 

• Size of Database
• Number of Tournaments
• Number of Players

---

Backup

The Backup Tab saves the current Database and HM2 configuration settings

• Clicking on the ... button on the right top corner changes the backup location of the backup file
• Start Backup = Starts the backup process
• When the backup is complete, it will display a "Backup Completed Message"

---

Restore

Restore loads a backup file created with the backup option

1. Select backup file
2. Select what configuration files to include
3. Choose to make a new blank database or overwrite the old database
4. Click Start Restore

---

Maintenance



 

Warning: Postgres is 3rd party software and we strongly suggest not using these features unless you are experiencing slow database performance.

Maintenance has two options.  Both options are custom PostgreSQL tuning options.

Optimize = Optimizes the database so queries are returned quicker and more efficently.

• Quick - Vacuum of all tables
• Standard - Vacuum of all tables and reindex of of indexes
• Full - Vacuum analyze of all tables and reindex of all indexes

PostgreSQL Tuning = Tunes the PostgreSQL configuration file based on PC specifications to help improve performance.

---

Import HM1 Databases

Import HM 1 databases here

• Database Connection - Select a HM1 Database to import into the current HM2 database.
• Hands to Import - Choose Import Hero Only hands or All Hands.
• Date Range - Select a date range for the HM1 imported hands.
• Click Start Import to start the import process.

**NOTE** 
Hands that were purged in an HM1 DB will not exist and cannot be imported into HM2. They will need to be reimported from the original hand history files.

---

Export Hands

Export hands from your HM2 database

• Output Directory - Select a folder to save hands in. 
• Date Range - Select a date range of the hands to export.
• Hands to Export - Select Hero Only or All
• Game Type - Select Cash or Tournament
• Stakes - Select the stakes to export
• Start Export - Start the hand export process.

---

Purge Hands

Purge removes selected hands from the database. Filter hands by:

• Game Type - Select Cash or Tourney
• Stakes - Select the stakes to remove
• Save Hands Played by - Use this to delete all other hands but hero hands
• Poker Sites - Select all sites or a specifc site to purge hands from
• Date Range - Select the date range of the hands to purge
• Purge Button - Starts the Purge Process.

*This is not recommended as the databases in HM2 only take up about half the space of HM1. Stats will not be saved after purging hands.* 

---

HM Sync
HM Sync allows the combination of databases across two PC's.

HM Sync uses HoldemManager.com email and password for validation.