PDA

View Full Version : Export database



Hanske333
10-11-2009, 02:16 PM
Hi,

My HEM is once again going totally bananas. I keep getting the failed to establish connection error, and because i'm no computer genius i'm not going through the hours of technical steps here provided. So i just want to export my database, uninstall evrything and then reinstall and reimport evrything. Problem is, i can't export the normal way because i can't access HEM. Anyone has a clue how to do it via another way?

thanks

fozzy71
10-11-2009, 06:13 PM
Please update to the latest beta - http://www.holdemmanager.com/downloads/HmBetaUpdate.exe


You have 4 main ways of restoring a postgresql database.

1) use the existing copy of your \data folder and reinstall the same version of postgresql over it.


For reinstalling SQL to the same DB follow these steps:

1) Uninstall PostgreSQL from the Windows Control Panel.
2) If you are moving the DB to a different drive/partition, manually cut or copy the \Postgresql\data directory to it's new location.
3) run the command - start > run > cmd >

net user postgres /delete
4) reboot.
5) Install the same version of PostgreSQL as your current DB using these instructions - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=177
6) If you have moved/installed your DB to a non-default location, please make sure to change the 'Data Directory' path during the installation.


2) reinstall sql, and create a new utf db, and restore a .backup file.

3) reinstall sql and cluster a new/empty db, and import your \HMArchive file of original/processed hands, and any other exported/archived hand files. (see the end of my post)

4) the other variation of the above, is after you create that clean empty db, you copy the 5 postgresql config files to your old \data, uninstall sql, and reinstall the old DB again, with the new config files.



My suggestions for you, if everything is still installed and not able to connect is, in order of quickness to get reconnected:


Under Vista and Windows 7 make sure UAC is disabled http://www.holdemmanager.net/faq/afmmain.aspx?faqid=73 and/or holdemmanager.exe and hmhud.exe are started as administrator. Run the windows explorer and navigate to your Holdemmanager installation directory. Right click the holdemmanager.exe and the hmhud.exe executable and select "Run as admin" from the popup menu.

First try a simple reboot.

If no help, try this:

Start > Programs > PostgreSQL > 8.x > Stop Service

Start > Programs > PostgreSQL > 8.x > Start Service

Add exceptions to the windows firewall, even if it is off. If you have a 3rd party firewall, uninstall it completely before installing HM/SQL - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=171

Please try following all of these FAQs, step by step:

1) http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=34
2) http://www.holdemmanager.net/forum/showthread.php?t=8261

If that doesn't help, I would suggest a clean reinstall of postgresql, not HEM.


For uninstalling SQL please follow these steps:

1) Uninstall PostgreSQL from the Windows Control Panel.
2) manually delete or rename the Program Files\Postgresql folders
3) run the command - start > run > cmd >

net user postgres /delete
4) reboot.
5) Install PostgreSQL 8.4, with your firewall uninstalled or turned off if windows firewall - http://www.enterprisedb.com/products/pgdownload.do#windows



Obviously, if you need help with any of this, for any reason, Please email me at fozzy@holdemmanager.net with a link to this thread, so we can schedule a Teamviewer session. Download and install the www.Teamviewer.com Quick Support version. Please let me know what time zone you are in and what time/days are convenient for you.

Hanske333
10-12-2009, 12:44 PM
I got in my HEM and i decided to export my whole database. It seemed better to just uninstall and reinstall evrything because their seemed to be alot of different errors. After reinstalling evrything end importing all the hands back in HEM it seems that all hands after june are missing. If i choose my name as hero name it says HEM has 175k hands but once i click on it, it only shows 110k. Ofcourse i have no filters on so i wonder where those other 65k hands might have gone?
thanks in advance

Hanske333
10-12-2009, 01:17 PM
I found that there is a difference between the hands pre june and after june.
The hands prejune are stored in notepad files in one very long line with all action after eachother which seems unreadable but copy/pasting it here gives this:

Texas Hold'em $0.15-0.30 NL (real money)
Table Mendoza
Hand #P4-97578418-1233
Started At 2 Jun 2009 06:48:21 PM ET
Ended At 2 Jun 2009 06:48:45 PM ET

Button is Seat 7
Seat 8: xxx [ Kd, Qc ] ($30.00 in chips)
Seat 9: xxx ($30.00 in chips)

ANTES/BLINDS
xxx posts small blind ($0.15), xxx posts big blind ($0.30).

PRE-FLOP
xxx raises $0.90, xxx calls $0.75.

FLOP [ board cards 3d,Kc,Kh ]
xxx checks, xxx bets $1.20, xxx folds.

SHOWDOWN
xxx wins $3.20.

SUMMARY

The hands after june are stored like this in the notepad file:


***** History for hand R5-1430071-13 *****
Start hand: Mon Jul 13 14:57:49 GMT+0200 2009
Table: Salinas [1430071] (NO_LIMIT TEXAS_HOLDEM $0.05/$0.10, Real money)
User: xxx
Button: seat 7
Players in round: 4
Seat 9: xxx ($5.43)
Seat 1: xxx ($10)
Seat 2: xxx ($3)
Seat 3: xxx ($12.94)
xxx posts small blind ($0.05)
xxx posts big blind ($0.10)
xxx posts big blind ($0.10)
---
Dealing pocket cards
Dealing to xxx: [5c, Jd]
xxx raises $0.10 to $0.20
xxx folds
xxx calls $0.15
xxx folds
--- Dealing flop [Qd, Kh, 8s]
xxx checks
xxx bets $0.50
xxx calls $0.50
--- Dealing turn [Ad]
xxx checks
xxx bets $0.50
xxx calls $0.50
--- Dealing river [9h]
xxx checks
xxx checks
---
Summary:
Main pot: $2.50 won by xxx ($2.38)
Seat 9: xxx ($4.23), net: -$1.20, [Js, 9d] (PAIR NINE)
Seat 1: xxx ($9.90), net: -$0.10
Seat 2: xxx ($4.18), net: +$1.18, [3d, As] (PAIR ACE)
Seat 3: xxx ($12.94)
***** End of hand R5-1430071-13 *****

I guess now it should be an easy solution?(hopefully :))

greetings

Hanske333
10-12-2009, 01:43 PM
I remembered i hadn't installed beta patch 1.09 after reinstalling HEM. But sadly it didn't help, although i'm pretty sure both things are connected.

Hanske333
10-12-2009, 02:24 PM
i got the problem fixed, just made a new db and imported again :)

Bohonos
10-12-2009, 06:41 PM
when i try to download beta - http://www.holdemmanager.com/downloads/HmBetaUpdate.exe i get "the packageWAS unable to replace the file

fozzy71
10-12-2009, 07:18 PM
i got the problem fixed, just made a new db and imported again :)

Yep, you got it. Newest beta and new DB should cure it.


when i try to download beta - http://www.holdemmanager.com/downloads/HmBetaUpdate.exe i get "the packageWAS unable to replace the file

1) Clear your web cache, and download the beta update again, with another browser if possible.
2) Right-Click > Save Link As to save it to a different folder.
3) Reboot, and run the installer first thing.
4) Make sure the update is installing to the proper \holdem manager folder