PDA

View Full Version : hem 2 database move



Ashuran
10-22-2014, 04:32 PM
Hey guys,

I recently had to install a new ssd and was left with an old hdd (with all old files)which is not possible to boot on its own operating system. I found the database folders on that hdd, but don't know how to import them correctly to my new ssd with hem2 on it.

Below is a screen of the folder and files. How can i import any of these databases to my new database?

158042


hope that it is still possible to retrieve the data.

let me know.

fozzy71
10-23-2014, 02:29 PM
Please note that reinstalling PostgreSQL will mean losing all your old data. If you have access to HM2 and your database was not corrupt then please follow these instructions for backing up your database as a precaution in case you cannot reconnect after reinstalling PostgreSQL - http://hm2faq.holdemmanager.com/questions/1471/How+does+Backup+and+Restore+Database%2C+Settings+a nd+HUD+configs+work%3F


If you cannot access the database in HM2 then you can backup your database using this method: http://hm2faq.holdemmanager.com/questions/952/How+does+Backup+or+Restore+via+PostgreSQL+work%3F+ %28Advanced+Method%29 but if your database was corrupt then the best solution is to reimport all your hands from C:/HM2archive folder or if your pokersite supports it you can request all your hands and summaries and reimport them as restoring a corrupt database will just restore all the problems you had.


Once you have backed up your previous database(s) then follow the instructions below to uninstall and reinstall PostgreSQL using the same database.


1) Uninstall PostgreSQL from the Windows Control Panel.


2) Run the command - start > programs > accessories > command prompt > right-click > run as administrator and type the following and then press enter: net user postgres /delete
You should get a successfully completed response if done correctly. If you get a permission type error you likely didnt run it as administrator as explained above.


4) Reboot your PC


5) Install the same version of PostgreSQL as your previous database using these instructions - http://hm2faq.holdemmanager.com/questions/1591/Reinstall+PostgreSQL+8.4+while+preserving+database
http://www.holdemmanager.com/downloads/postgres84

*Pay close attention to the notes on the faq linked to in step 5 to make sure you copy over the parent folders from the HM2 roaming database folders.