PDA

View Full Version : Database's are WAY off!!! HELP plz!



4entourage
08-07-2009, 04:24 PM
I have tried 2 times now.....
I use my laptop as my primary database. I just formatted my normal desktop to Windows 7.

I go through PGAdmin - export my laptop database of 62,000 players. I go import it on the desktop and it has some 50,000 Import errors and only has 14,652 of hte players. I deleted the database on desktop. Re-exported from Laptop- put back on desktop to try again--- it got more players but still didn't even get close to half of what the laptop contains.....

netsrak
08-07-2009, 05:01 PM
I guess you are exporting hands and importing them again?

The players are no indicator for the correct import. Because when you purged hands the player count remains the same but in the new database you import no hands with this players involved so they are not counted.

I suggest you count the number of hands via pgadmin to compare the databases.

Start pgadminII
Connect to your database server via double click.
click on the holdemmanger database
Start the Query tool in the tools menue
Enter and run "Select count(*) from pokerhands

4entourage
08-07-2009, 05:07 PM
I guess you are exporting hands and importing them again?

The players are no indicator for the correct import. Because when you purged hands the player count remains the same but in the new database you import no hands with this players involved so they are not counted.

I suggest you count the number of hands via pgadmin to compare the databases.

Start pgadminII
Connect to your database server via double click.
click on the holdemmanger database
Start the Query tool in the tools menue
Enter and run "Select count(*) from pokerhands


All it shows is 444,897 when the other one (last time I ran about a week ago) had almost 4 million......

The player should have some fact on the right import or not.... I mean 14,000 vs 62,000 is a hell of a difference. I have never purged a single hand---- only manual vacummed.

4entourage
08-07-2009, 07:30 PM
The way I did it was from inside hem
---Options --- clicked Database Management
---Clicked "Connect"
---On my database name (CombinedDB's) I clicked "Export Hands"

Is this wrong?

Should I have done this through PGAdmin?
I see in PGADmin I can log in and go to "CombinedDB's" and click "Backup"
Should I have done it this way??

fozzy71
08-07-2009, 07:34 PM
Are both copies of HM version 1.09 Beta 23a?

4entourage
08-07-2009, 08:33 PM
One was 19a one was 21.. They are both 23 now... still no luck

4entourage
08-07-2009, 08:43 PM
The way I did it was from inside hem
---Options --- clicked Database Management
---Clicked "Connect"
---On my database name (CombinedDB's) I clicked "Export Hands"

Is this wrong?

Should I have done this through PGAdmin?
I see in PGADmin I can log in and go to "CombinedDB's" and click "Backup"
Should I have done it this way??

Should either of these ways work?

When I export the first way - it made a 4 gig file - I imported and it only gave me 16,000 players the 2nd time (of hte 65,000 I have)

When I did it through PGAdmin backup utility -- it was a 17 gig folder created in the "Program Files \ X86 \ PostgreSQL \ 8.3 \ data \ base

netsrak
08-08-2009, 04:44 AM
The two ways are totally different.

The HM export only exports the handhistories. http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=173
The pgadmin backup saves the whole database structure. This is usually faster although it contains much more data. http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=12

4entourage
08-08-2009, 11:37 AM
The two ways are totally different.

The HM export only exports the handhistories. http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=173
The pgadmin backup saves the whole database structure. This is usually faster although it contains much more data. http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=12

Well that helps me absolutely nothing with what I need to do! You havent answered me questions at all. So what do I need to do so that my 62,000 player/4million hand database is on my second computer because its not working


When I do the HEM hand export and put it on other PC - like I said - I get 16,000 players not 62,000. I get almost 500,000 hands not 4million. I have never purged hands !!!

netsrak
08-08-2009, 02:16 PM
Please schedule a remote support session with our support manager. Email fabio@holdemmanager.net, with a link to this thread and your forum name, so he can setup a Teamviewer (http://www.teamviewer.com) session.

4entourage
08-08-2009, 03:48 PM
If this helps at all.... I tried again for the 3rd time. Did it through PGAdmin. Backed up database. Put it on external drive. Brought it to new computer. Restored it.

Once it was finally done I get this error message:

http://img412.imageshack.us/img412/2738/errormessagec.th.png (http://img412.imageshack.us/i/errormessagec.png/)

"An error occurred when retrieving the player list: ERROR: 22P05: character 0x90 of encoding "WIN1252" has no equivalent in "UTF8"

netsrak
08-09-2009, 03:11 AM
Please schedule a remote support session with our support manager. Email fabio@holdemmanager.net, with a link to this thread and your forum name, so he can setup a Teamviewer (http://www.teamviewer.com) session.

You created the database with the wrong coding

4entourage
08-09-2009, 12:57 PM
You created the database with the wrong coding

Not to be disrepectful but how does that help me in any way? You simply make it so I need to respond again - so you can reply again. See at least Fabio knows what hes doing and simply says "Use SQL ASCI II" not just pointing out the obvious. Thanks FABIO!!!