PDA

View Full Version : backing up HEM database



shawshank
03-07-2010, 07:00 PM
I got a new computer and need to transfer the database from one computer to the next. But before I do the transfer, I wanted to: (1) backup the database.

My first question is: how do I backup the current hand histories as a safeguard (see below)? IOW, where are the files & what are the specific steps?


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.

My second question is: I have opened pdAdmin III & found the page w/ the databases listed based on the directions in the FAQs (BACKUP & RESTORE DATABASE). My second question is: Is the filename @ the top of HEM the filename for my HEM database (in pgadmin III)?

Thanks. s/s.

morny
03-08-2010, 12:38 AM
Hi,

If your doing a clean reinstall or moving HM to a new computer you should consider the following.

Export and Import your Hand Histories and/or backup and restore your database
FAQ - Hold'em Manager Poker Tracking Software :: How to Import & Export Hands (http://faq.holdemmanager.com/questions/98/How+to+Import+%26+Export+Hands)
FAQ - Hold'em Manager Poker Tracking Software :: Backup & Restore Database (http://faq.holdemmanager.com/questions/72/Backup+%26+Restore+Database)

Export Your Notes
http://faq.holdemmanager.com/images/notes-02.jpg

Export Your Bonuses and Rakeback - Options > Rakeback & Bonuses http://faq.holdemmanager.com/images/rakeback-bonuses-01.jpg

Export any tourney summaries by selecting all your tournaments in the Data View Sub-Tab of the Tourney > Results Menu and choose Export Tourney Results and summaries

http://faq.holdemmanager.com/images/tourney-data-view-01.jpg

See this FAQ FAQ - Hold'em Manager Poker Tracking Software :: Registration Benefits (http://faq.holdemmanager.com/questions/26/Registration+Benefits) on how to reset your code

and finally
FAQ - Hold'em Manager Poker Tracking Software - Reinstalling HEM without Losing Preferences (http://faq.holdemmanager.com/questions/99/Reinstalling+HEM+without+Losing+Preferences+)

And yes that is the database name in the tiltle bar of HM

shawshank
03-08-2010, 01:19 PM
I have backed up the database & saved the hand histories & followed the steps listed above. I have also downloaded HEM to my new computer. I have also transferred the database file to the new computer. But I do not know the password for postregsql when I am prompted for it. (I made no changes and followed the default download for HEM omaha.)

I have attached a file that gives the specific error.

thanks!!!!:rolleyes:

fozzy71
03-08-2010, 10:04 PM
postgrespass

shawshank
03-08-2010, 10:04 PM
BTW, my OS = windows 7. I think this is one of those times when you need to disable the settings. (but I don't know how.) :D

fozzy71
03-08-2010, 10:34 PM
PT3's default name/password is - postgres/dbpass
HM's default name/password is - postgres/postgrespass

Start HM > Options > Database Management > Password:

If that doesnt help:

1. Go to C:\Program Files\PostgreSQL\8.x\data, move the the pg_hba file to your Desktop and open it with notepad.
2. Scroll to the bottom and change all md5 to trust. Save and close the file
3. Move the file back to the data folder
4. Restart the PostgreSQL service: Control Panel -> Administrative Tools -> Services

HM will accept any password now.

FAQ - Hold'em Manager Poker Tracking Software :: Password Issues (PostgreSQL) (http://faq.holdemmanager.com/questions/82/Password+Issues+(PostgreSQL)/)

shawshank
03-09-2010, 09:44 PM
Next question. I have backed up the database & the HH & tourney histories & moved them to the new computer. I have run thru the postregsql & pointed it to the file that contains the backed up database. However, when I open HEM on the new computer, I still get zero hands + zero players. IOW, HEM is not recognizing the backed up database. I"m also concerned that the file size for the backed up database is too small (237 KB for approx 40K players).

Does this sound right? How do I reopen the database & get it imported back into HEM on the new computer once I have backed up & moved the database onto the new computer? (must be in the FAQs?)

tx. s/s.

fozzy71
03-09-2010, 10:25 PM
Next question. I have backed up the database & the HH & tourney histories & moved them to the new computer. I have run thru the postregsql & pointed it to the file that contains the backed up database. However, when I open HEM on the new computer, I still get zero hands + zero players. IOW, HEM is not recognizing the backed up database. I"m also concerned that the file size for the backed up database is too small (237 KB for approx 40K players).

You are restoring a .backup file, and the file is only 237KB? That is far too small for a DB Backup.


Does this sound right? How do I reopen the database & get it imported back into HEM on the new computer once I have backed up & moved the database onto the new computer? (must be in the FAQs?)

tx. s/s.

Is this the process you used to backup and now restore the DB?

FAQ - Hold'em Manager Poker Tracking Software :: Backup & Restore Database (http://faq.holdemmanager.com/questions/72/Backup+%26+Restore+Database)


If the .backup won't restore properly I suggest you just make a new DB and import your archived and exported files. If you play a site like stars/ftp you can email their support and ask for all your old hand histories and tourney summaries.

shawshank
03-10-2010, 05:09 PM
So how do I make a new database? I have imported the hands from files in the past. And I backed up my database hand histories that contains 731 files & its total size is 648 MB. Does that file size sounds right for 40K players? And, if so, should I just import the hands from this file folder (using HEM autoimport IMPORT FILES option)?

shawshank
03-10-2010, 05:44 PM
I've also backed up tourney (150KB) & rakeback (1KB). So shouldn't I be able to just reimport those files to get my old database back?

Plus how do I create a new database?

Tx. s/s.

fozzy71
03-10-2010, 08:56 PM
Yes, you can create a new DB, import the hands, and then the tourney results and rakeback.

*Try creating a new UTF DB - FAQ - Hold'em Manager Poker Tracking Software :: Create / Delete Database (http://faq.holdemmanager.com/questions/75/Create+%7B47%7D+Delete+Database)
*Now import a small portion of your \HMArchive so you can see if the problem exists in the new DB - FAQ - Hold'em Manager Poker Tracking Software :: How to Import & Export Hands (http://faq.holdemmanager.com/questions/98/How+to+Import+%26+Export+Hands)
*If the new DB seems to work properly, you will want to import the rest of your archives to the new DB, export/import the hands from the old DB to the new DB, and export/import any player notes and tourney summaries - and then delete the old DB.
*Make sure you export/backup everything before deleting the old DB