Problem exporting just my own hands

[bw07507]

Hi, I recently bought a new computer and am trying to export all of my individual hands so that i can import them on my new computer. I don't want all of the hands in my database as I have datamined in the past and have over 10GB worth of HHs from other players in my db.

In HEM, I try going to the Hands tab and selecting All hands, but I have over 1 million hands in the database and it freezes and gives me an error every time I try to do this. Is there an easier way to export just my own hands from HEM?

[fozzy71]

Fair warning, a good portion of your 10gb DB' is being taken up by unnecessary log files. Instructions at the end of this post for turning it off and deleting them.

Purge all hands that you (your alias) did not play in, as well as any observed hands.

*Please make sure you select your Alias that contains ALL of your various site screen names, so you don't purge your own hands.

http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=152

http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=107


Now do a bulk export.

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


And when importing on the new PC/DB, make sure you go to:

Options > Observed Hand History Configuration > Do not insert any Observed Hand Histories.


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.