PDA

View Full Version : Importing old base without backup files and hand backup files



justins
03-02-2014, 01:15 PM
Hello everyone, I've got a problem. I have an old PC with a HM1 base or bases. I've got only PostgreSQL\data\base saved folder, no backup files and no backup hand files. Is it possible to restore base from this files? Folder "base" has a few folders like "17325", "2586" and many files without extension into this folders like "1247", "2605" etc. "PostgreSQL\data\base " takes up 67Gb

justins
03-02-2014, 01:18 PM
Hello everyone, I've got a problem. I have an old PC with a HM1 base or bases. I've got only PostgreSQL\data\base saved folder, no backup files and no backup hand files. Is it possible to restore base from this files? Folder "base" has a few folders like "17325", "2586" and many files without extension into this folders like "1247", "2605" etc. "PostgreSQL\data\base " takes up 67Gb

fozzy71
03-02-2014, 03:16 PM
Each of those numbered sub-folders in \base is a different database (could be HM1, HM2, PT4, etc).

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

1) Uninstall PostgreSQL from the Windows Control Panel.
2) If you are moving the DB to a different drive/partition, manually cut or copy the \Postgresql\8.x\data directory to it's new location.
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://faq.holdemmanager.com/questions/71/Reinstall+PostgreSQL+Preserving+Old+Database

http://www.holdemmanager.com/Downloads/postgresql-8.4.17-1-windows.exe

6) If you have moved/installed your DB to a non-default location, please make sure to change the 'Data Directory' path during the installation.