Overview:
How do I backup and Restore my HM1 Database? (Try our new Backup/Restore utility. Click Here)
Note: This FAQ is intended for Advanced PC Users Only!!!
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.
Note: To increase the chance of this working, make sure you install the same version of PostgreSQL that housed your old database.
Note: Never restore a DB .backup file that was created with PGAdmin into a new DB that was created by the HM DB Control Panel. If it was backed up with PGAdmin, it must be restored with PGAdmin.
Backup Database
- In your desktop, navigate to Start > All Programs > PostgreSQL 8.x > pgAdmin III.
Similarly, you can navigate to C:\Program Files\PostgreSQL\8.x\bin\ and clicking on the elephant icon called pgAdmin3.exe.
The pgAdmin III screen should pop up.
2. Double click on PostgreSQL Database Server 8.x in the object browser field. You may be prompted for your password.
3. Enter your password if prompted. This is your password that you used when setting up PostgreSQL. Upon successful authentication, you will see the properties tab populate as shown in the screenshot below:
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.
5. Right click on the database you selected and choose Backup. A Backup Database dialog will pop up.
6. In the Filename field, click on the ellipsis button and choose a name and location where you want to save it to.
Note: Click on Browse Folders to select a location.
7. Click on OK.
Note: Leave all the default settings as they are. Remember the location as this is where you'll need to restore it from.
The selected database will now begin backing up. While it's backing up, it may become unresponsive. You will know it's finished when the OK button, which is grayed out during backing up, changes to Done.
8. Click Done.
The selected database has now been backed up.
Restoring Your Database
Note: Its extremely important that you only restore a database to a blank database created via the method below. 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.
To restore your database, do the following
1. In your desktop, navigate to Start > All Programs > PostgreSQL 8.x > pgAdmin III.
Similarly, you can navigate to C:\Program Files\PostgreSQL\8.x\bin\ and clicking on the elephant icon called pgAdmin3.exe.
The pgAdmin III screen should pop up.
2. Double click on PostgreSQL Database Server 8.x in the object browser field. You may be prompted for your password.
3. Enter your password if prompted. This is your password that you used when setting up PostgreSQL. Upon successful authentication, you will see the properties populate as shown in the screenshot below:
4. In pgAdmin, click on Edit > New Object > New Database. A New Database dialog will pop up.
5. In the Properties tab, enter a new name and leave everything else as default. Click OK.
6. In pgAdmin III, xpand the Databases folder and select the new database, right click and select restore. A Restore Database dialog will pop up.
7. In the Filename field, click on the ... button and go to the location where the backup file is located and click Open.
8. Leave all the default settings as is and click OK.
9. The restoring process might end with an error, just click cancel and do not click Ok to restore again.
The selected database is now restored.