PDA

View Full Version : Exported db from old computer, imported on new, stats are way off



ata
10-29-2009, 02:30 PM
Hi,

I got a new computer and setup HEM on it. I installed Postgre 8.4. I tried backing up my old db and then restoring it, but it didn't work (I assume because of one db being from 8.3 and the new one being 8.4). So I exported all the hand histories from my old db and then imported them into a fresh DB on my new computer. All seemed to go well.

However, I loaded up a session today, and to my surprise, everone's stats were way off. Regulars who I play with who I know play 20/17 were all of a sudden showing 29/22. This is over 100k hands for them. Every single person had stats of like 40/30 instead of their normal 25/20. I have no idea why this is.

My stats seem to be normal, but everyone who I have datamined stats for is all messed up. All data came from the export function from my old database and then was re-imported normally into the fresh database.

Any ideas why this is or how to correct it?

Thanks.

ata
10-29-2009, 03:33 PM
Some more info: the stats are the same incorrect stats both through the HUD and through a report in HEM. Also the same incorrect stats in Spade Eye. So it's not a filter or something that's messing it up somewhere. I really think it had something to do with the exported hands being messed up or something. Also my old DB was in SQL_ASCII, this new one I setup in UTF (postgre 8.4) since that's what you recommended. Not sure if that could be a problem.

netsrak
10-29-2009, 05:01 PM
Yes thats the problem.
You need to create the database with the same coding as the old one.
UTF8 is only for new empty databases not for restoring old ones.

ata
10-29-2009, 05:13 PM
Thanks for the reply.

Is there any downside to keeping my database in SQL_ASCII? Why did you guys recommend switching to UTF?

ata
10-29-2009, 05:17 PM
Also do I have to change anything in Postgres to switch to SQL_ASCII? I don't recall the 8.4 installer asking me what type of encoding I wanted. So all that I'd need to do is tell HEM to make a SQL_ASCII database when I create it through the HEM database manager?

I can perhaps just re-import the old hand histories if I can find them if it makes sense to switch to UTF - which is why I'm wondering if there's any downside to leaving it in SQL_ASCII.

fozzy71
10-29-2009, 06:34 PM
Thanks for the reply.

Is there any downside to keeping my database in SQL_ASCII? Why did you guys recommend switching to UTF?

If your current DB is ascii and not having problems, there is no need to worry about UTF until you make a new DB. When you make a new DB it will give you the option, but default to UTF.

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



Also do I have to change anything in Postgres to switch to SQL_ASCII? I don't recall the 8.4 installer asking me what type of encoding I wanted. So all that I'd need to do is tell HEM to make a SQL_ASCII database when I create it through the HEM database manager?

If you are making a new empty DB, using the HEM DB Control Panel, to import hands, you want to choose UTF.


I can perhaps just re-import the old hand histories if I can find them if it makes sense to switch to UTF - which is why I'm wondering if there's any downside to leaving it in SQL_ASCII.

If you want to make a new DB for any reason, this is the process.

First make sure you export any hands, player notes, and tourney summaries.

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.

Make sure you export your tournament summaries: Tourney > Results > Dataview > All Hands > Right-Click > Export Tourney Results and Summaries.

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

HM > Options > Database Management > Connect > Export Hands

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

Make sure you copy that folder as well as the other stuff I mentioned.


*Try creating a new UTF DB - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=146
*Now import your \HMArchive, exported hands, summaries, notes - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=173
*then delete the old DB. - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=21

ata
10-29-2009, 07:50 PM
Thanks for the help.

I don't have all my old archived hand history files. They only exist in my database (SQL_ASCII) on my old computer now. So you're saying there's no way to transfer those hands to my new UTF database? Because I tried to export them and then re-import them into the new fresh UTF database I created, and the stats become messed up as I noted above.

Is there any way to get all the old hands from my old database into the new one? Or am I skewered because I don't have the original archived text files?

ata
10-29-2009, 07:52 PM
Yes thats the problem.
You need to create the database with the same coding as the old one.
UTF8 is only for new empty databases not for restoring old ones.

I tried creating a fresh database with SQL ASCII coding in the DB manager and got the error ""ERROR 22023: new encoding (SQL_ASCII) is incompatible with the encoding of the template database (UTF8)"

Is there any way to create a SQL_ASCII database with postgres 8.4?

fozzy71
10-29-2009, 08:03 PM
Try using PGAdminIII to create a new DB and make sure you change from the defaultl UTF encoding.

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

http://i207.photobucket.com/albums/bb176/fozzy71/HEM/hem-db-encoding.png


Then you should be able to either try a .backup/restore or you can try to open the HEM DB Control panel and use the new ASCII DB.