PDA

View Full Version : Import problems after backup



laurensds
12-19-2009, 02:48 PM
Hi,

Today I made a backup of my holdem manager on my desktop to restore the same database on my laptop.
So, my laptop was totally clean, I just formatted it, nothing installed yet.
So I made a backup of my desktops HEM using pgadmin III. So far so good.

After that I installed postgre on my laptop and I also installed HEM. Everything went fine.
Then I restored my database using pgadmin again. I didn't get any errors so I thought everything would be ok.

I started my pokerclient, edited auto import folder etc, sat down at some tables and then I saw that HEM was importing most of my hands but not all of them... No errors were given thoug. I tried a few times (different tables/stakes) but always the same problem kept coming up, that it imported most of the hands but not all.

How can I fix this?

fozzy71
12-19-2009, 04:51 PM
Which Operating System, Firewall, and Anti-Virus are you using?

Which HM version? Please update to the latest beta - http://www.holdemmanager.net/hmbetaupdate

Which version of Postgresql on each machine? How big is the DB and backup?

The backup/restore is never 100% guaranteed to work, which is why it's important to save your archived hands. If you play a site like stars/ftp you can email their support and ask for all your old hand histories and tourney summaries.

*Try creating a new UTF DB - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=146
*Now import a small portion of your \HMArchive so you can see if the problem exists in the new DB - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=173
*If the new DB seems to work properly, you will want to import the rest of your archives to the new DB, export/import the hands from the old DB to the new DB, and export/import any player notes and tourney summaries - and then delete the old DB. - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=21

Make sure you export/backup everything before deleting the old DB - http://www.holdemmanager.net/forum/showthread.php?t=20754

laurensds
12-19-2009, 04:59 PM
Which Operating System, Firewall, and Anti-Virus are you using?

Which HM version? Please update to the latest beta - http://www.holdemmanager.net/hmbetaupdate

Which version of Postgresql on each machine? How big is the DB and backup?

The backup/restore is never 100% guaranteed to work, which is why it's important to save your archived hands. If you play a site like stars/ftp you can email their support and ask for all your old hand histories and tourney summaries.

*Try creating a new UTF DB - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=146
*Now import a small portion of your \HMArchive so you can see if the problem exists in the new DB - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=173
*If the new DB seems to work properly, you will want to import the rest of your archives to the new DB, export/import the hands from the old DB to the new DB, and export/import any player notes and tourney summaries - and then delete the old DB. - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=21

Make sure you export/backup everything before deleting the old DB - http://www.holdemmanager.net/forum/showthread.php?t=20754

-Windows 7, no firewall or scanner
-both computers have latest beta
-on my desktop I have postgre 8.3 on laptop 8.4
- this "C:\Program Files (x86)\PostgreSQL\8.3" map is about 35 gig, the backup is 1.3gig

fozzy71
12-19-2009, 08:55 PM
Please try reinstalling the SAME version (8.3) on the laptop. Hopefully the restore will be successful using the same version.

Please update to the latest beta - http://www.holdemmanager.com/downloads/HmBetaUpdate.exe

For reinstalling SQL to the same DB, follow these steps:

1) Uninstall PostgreSQL from the Windows Control Panel.
2) Delete the \Postgresql\8.x\data directory
3) run the command - start > programs > accessories > command prompt > right-click > run as administrator

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, or want to, please make sure to change the 'Data Directory' path during the installation.