Back-up thread?

[Renevk]

Hey,

I'm going to reboot my PC. What's the best way to make a back-up of my HH? Is there a guide on this forum about back-up HHs?

Thx,

Renevk

[netsrak]

We have a FAQ ;)
For backing up your database: http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=12

For exporting handhistories: http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=173

For saving your settings: http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=98

[mak]

We have a FAQ ;)
For backing up your database: http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=12

For exporting handhistories: http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=173

For saving your settings: http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=98

I'm rebooting also. I followed the three steps above. I also want to make sure my customized pop-up configurations remain the same. I think the configurations are saved as xxx.pop files in the "Config" folder. So, I'm thinking the "saving your settings" step will also preserve your customized pop-ups. Is that correct?

Also, will we need a new registration code, or will our old one work?

As a final note, I figure I should export my Holdem Notes as well (in case the backed up database fails).

Is there anything else to do?

[fozzy71]

I'm rebooting also. I followed the three steps above. I also want to make sure my customized pop-up configurations remain the same. I think the configurations are saved as xxx.pop files in the "Config" folder. So, I'm thinking the "saving your settings" step will also preserve your customized pop-ups. Is that correct?

Correct. The .pop files are in the \config folder


Also, will we need a new registration code, or will our old one work?

The old one will probably work, but you may need to use the PC#2 slot when registering it. If this is not the case, you can emailsales@holdemmanger.net and have your license reset.


As a final note, I figure I should export my Holdem Notes as well (in case the backed up database fails).

Is there anything else to do?

Here are my cliff notes for uninstalling and reinstalling HM and PostgreSQL on a Vista PC. Some of the uninstall stuff won't apply to you, if you are doing a complete Operating System reinstall/reformat.



Vista: Turn off UAC - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=73

Turn off Windows Firewall for installing HM and PostgreSQL. Once you get those installed you can add exceptions to the firewall. If you have a 3rd party firewall, uninstall it completely before installing HM/SQL - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=171


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)


How do I re-install PostgreSQL and use a previous database? (http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=177)


How do I backup and restore my database? (http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=12)


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



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. It is also a good idea to export any non-default HUD configs you have created to XML file.

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

HM > Options > Database Management > Connect > Export Hands

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.




Logging:

I would suggest you turn off logging on your new SQL installation as well as these other performance improvements - Top 10: HEM performance increase tips
(http://208.109.95.123/forum/showthread.php?p=62613&posted=1#post62613)

To turn off logging, follow these instructions. This is the first thing I do anytime I install SQL for someone.

- Start > My Computer > Tools > Folder Options > View > UnCheck 'Hide Extensions for known file types' > OK

- C:\Program Files\PostgreSQL\data\postgresql.conf > Right-Click > Open With.. > NotePad > Check 'Always use this program'

- Scroll about half way down to ~Lines 245 - 260:

- The last line of this block of code, for the 'logging_collector', must be changed from On to Off.


------------------------------------------------------------------------------
# ERROR REPORTING AND LOGGING
#------------------------------------------------------------------------------

# - Where to Log -

log_destination = 'stderr' # Valid values are combinations of
# stderr, csvlog, syslog and eventlog,
# depending on platform. csvlog
# requires logging_collector to be on.

# This is used when logging to stderr:
logging_collector = off # Enable capturing of stderr and csvlog

File > Save; File > Close

Start > Programs > PostgreSQL 8.3 > Reload Configuration.

*edit:
- Start > My Computer > C:\Program Files\PostgreSQL\data\pg_log, or C:\Program Files (x86)\PostgreSQL\data\pg_log, if you have 64 bit Vista. Delete all files in that folder. And it might be a good idea to empty your recycle bin at that point, or use a 3rd party utility like CCleaner to clean up all your junk/temporary files. You want to do this before you get to the vacuum and defrag process.


Installing HM:

When reinstalling HM, install the full setup, then the latest beta patch and finally paste in your config folder. Then the only thing left would be importing your exported notes. Your HUD should be the same as it was.