PDA

View Full Version : Some questions on backing things up.



ALLTIMESLUCK
07-06-2009, 11:43 AM
Hey guys, bit of a computer donk here so I have a few small questions on how and where HEM data is stored. I've been reading through the FAQs and the manual but have just confused myself more.

As far as I understand...

> HUD and other config files are stored in the HEM folder (normally C:\Program Files\RVG Software\Holdem Manager).
> HH's are stored in the DB, and the file for that is located in my postgres folder.

So...

> Are notes stored in the DB?
> You can export and import HH's to and from the DB. Is this equivalent to backing up the DB itself or is there a reason to do one over another?
> What is the HMArchive folder for?

I'm just trying to get a handle on all of this so that I can do regular backups easily and know what exactly I'm doing. Any help is appreciated.

Thanks

fozzy71
07-06-2009, 12:04 PM
Hey guys, bit of a computer donk here so I have a few small questions on how and where HEM data is stored. I've been reading through the FAQs and the manual but have just confused myself more.

As far as I understand...

> HUD and other config files are stored in the HEM folder (normally C:\Program Files\RVG Software\Holdem Manager).
> HH's are stored in the DB, and the file for that is located in my postgres folder.

- The config files are in the \Holdem manager\Config folder. You can also export your various custom HUD configs to XML file, so you or anyone can import them again.

- The HHs are imported to an SQL DB, and then the originals are moved to the C:\HMArchive folder.



> Are notes stored in the DB?
> You can export and import HH's to and from the DB. Is this equivalent to backing up the DB itself or is there a reason to do one over another?
> What is the HMArchive folder for?
...

- You can import notes to HM from some sites. You can also export all of your notes to XML file, to import again later if you are reinstalling. That file gets exported to the main \Holdem Manager directory.

- Exporting the entire DB to text HH files is the first thing you should do before considering a reinstall. Those hands are exported to their own new folder, which will be named after the DB itself: \Holdem Manager\HandHistoryExport_DataBaseName.

Technically, all the hands you need should be in the Archive folder, but I would rather be safe than sorry. The text files can be compressed dramatically using a program like www.7Zip.org, so storage space concerns for your archives shouldn't be an issue.

- HMArchive is explained above.

fozzy71
07-06-2009, 12:21 PM
Forgot to add a couple FAQs and some cliff notes:


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)


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)

That FAQ is in need of an update, so here are some additions:

You want to make sure you backup your Processed/Archived hand histories, your entire \config folder, and your exportednotes file. I usually just copy my entire \Holdem Manager directory.

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.


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)

ALLTIMESLUCK
07-06-2009, 12:53 PM
Much obliged Fozzy