Database Restore Problems, Hands not showing.

[CrAAdle]

Hi,

I just re-installed Windows 10 on my computer and installed a fresh HM2 w/ Postgre. When I restore my old database, 1min after the restoration process I get an error message "Error 55006 database "name" is being used by another user" I say "ok" and the restore continues. After 10-15min or so the restoration is over and it asks me to restart HM2.

My player names and HUD configurations are there, the database size is 5016 MB but I can't see any hands. I tried restarting my PC and HM2, it doesn't work.

However, I tried exporting hands to see if they are there, they are! I can export hands on a chosen date but I can't see them in HM2! Yes I have cleared all filters etc..

I suppose I can export ALL hands and re-import them into a new database but I don't think that's the best option (i'll do that as a last resort).

What shall I do? Thanks in advance for your help.

[udbrky]

Please try to vacuum/analyze and reindex your database - Hold'Em Manager 2 FAQs - Poker Software :: Database Manager (Ribbon) (http://hm2faq.holdemmanager.com/questions/5/Database+Manager+%28Ribbon%29#maintenance)

If you continue to have problems, try the following:

Try creating a new DataBase and import a small portion of your \HM2Archive so you can see if the problem exists in the new DB - Hold'Em Manager 2 FAQs - Poker Software :: How to create a new database and import previously played hands (http://hm2faq.holdemmanager.com/questions/3091/How+to+create+a+new+database+and+import+previously +played+hands)

If the new database seems to work properly, it sounds like your database might be corrupt. Please continue to use the new database and import the rest of your hands using the steps above. This is why regular backups are a good idea. If your database becomes corrupt you can restore a backup and only have to import the most recent hands (that were played after the backup was created) and edit any tournament results if necessary. I recommend keeping at least the most recent 2 or 3 backups in case the most recent one does not restore properly you can try the previous backup.

Here is a FAQ explaining how to backup your database and all settings in one easy step - Hold'Em Manager 2 FAQs - Poker Software :: How does Backup and Restore Database, Settings and HUD configs work? (http://hm2faq.holdemmanager.com/questions/1471/How+does+Backup+and+Restore+Database%2C+Settings+a nd+HUD+configs+work%3F)

Please see this FAQ to transfer/backup data - Hold'Em Manager 2 FAQs - Poker Software :: What Files Should I Backup to Protect my Holdem Manager? (http://hm2faq.holdemmanager.com/questions/2151/What+Files+Should+I+Backup+to+Protect+my+Holdem+Ma nager%3F)

This will ensure that you have your hand histories and HUD saved to import into a new computer, and as a backup to restore in case of an emergency. I recommend you do this at least once a month and keep the last 2 or 3 most recent backups (and your \HM2Archive folder) stored on an external drive and/or cloud storage site like dropbox or google drive.