Problem restoring backup database and/or importing old archive
Results 1 to 6 of 6
  1. #1
    Junior Member
    Join Date
    Jan 2010
    Posts
    4

    Default Problem restoring backup database and/or importing old archive

    Hi,

    I had to wipe my computer due to a virus. I backed up the database following the instructions on site. I have now reinstalled the same versions of HEM and postgres that I was running before.

    I tried following the instructions on site to restore the db. I set up a new db with the default settings, ran the restore, got the error message, and hit cancel. However, when I open HEM none of the data is there.

    I have also tried setting up ascii and UTF databases and trying to both restore and import the archive. The restore doesnt work and I get massive amounts of errors on the hand history archive. Again, no cash game data is imported.

    Please help, thank you!
    Last edited by drkamikaze; 01-28-2010 at 07:50 AM.

  2. #2
    HM Support netsrak's Avatar
    Join Date
    Feb 2009
    Location
    Germany
    Posts
    25,795

    Default

    You need to create the new database via pgadminII and make sure you use the same coding as the original database. If its an older database this probably is SQL_ASCII.

    If you want to import the handhistory files:
    - make sure you are using Holdemmanager 1.10.01
    - create a new empty UTF database in Holdemmanager
    - import the hands via import file or import from folder.

  3. #3
    Junior Member
    Join Date
    Jan 2010
    Posts
    4

    Default

    Quote Originally Posted by netsrak View Post
    You need to create the new database via pgadminII and make sure you use the same coding as the original database. If its an older database this probably is SQL_ASCII.

    If you want to import the handhistory files:
    - make sure you are using Holdemmanager 1.10.01
    - create a new empty UTF database in Holdemmanager
    - import the hands via import file or import from folder.
    Ok, I created a new database via pgadminIII in ascii format and the restore still didn't work.

    I also updated to Holdemmanager 1.10.01, created a UTF database in HEM, and tried importing the archive. Pokerstars hands seemed to import fine, but FTP and UB hands did not. I still wound up with massive errors and 0 hands on FTP and UB.

  4. #4
    Junior Member
    Join Date
    Jan 2010
    Posts
    4

    Default

    I also just tried again creating an ASCII database and restoring, and the program just seems to freeze for hours.


    Quote Originally Posted by drkamikaze View Post
    Ok, I created a new database via pgadminIII in ascii format and the restore still didn't work.

    I also updated to Holdemmanager 1.10.01, created a UTF database in HEM, and tried importing the archive. Pokerstars hands seemed to import fine, but FTP and UB hands did not. I still wound up with massive errors and 0 hands on FTP and UB.

  5. #5
    Senior Member _Loki_'s Avatar
    Join Date
    Jul 2009
    Location
    B/ham UK
    Posts
    2,856

    Default

    Try this maybe:

    Create a database called 'test' say & make it your DEFAULT database for now

    Create three folders on your desktop call them ps, ftp & UB
    Copy/Paste some (100?) ps hands only into the ps folder from your HM Archive
    Do the same with ftp only hands into the ftp folder
    & ub hands only into the ub folder

    Try importing into the 'test' db from each folder seperately & see if it freezes for a particular folder

    At least you will have a better idea what the problem is doing this

  6. #6
    *** HM3! *** fozzy71's Avatar
    Join Date
    Jun 2005
    Location
    HM Support
    Posts
    32,838

    Default

    Send me some of the archived/original hands that are giving you errors. Please www.7zip.org the hands and email them to me at fozzy@holdemmanager.net, with a link to this thread.

Similar Threads

  1. Trouble restoring database
    By dojokid in forum Manager General
    Replies: 3
    Last Post: 11-02-2009, 07:12 PM
  2. restoring database on 2nd computer
    By djfl in forum Manager General
    Replies: 14
    Last Post: 07-17-2009, 06:01 AM
  3. Problem with restoring the database
    By tizzl in forum Manager General
    Replies: 1
    Last Post: 05-12-2009, 01:34 PM
  4. Problem with restoring database
    By smell777 in forum Manager General
    Replies: 10
    Last Post: 11-18-2008, 02:49 PM
  5. Need help restoring database
    By osiris873 in forum Manager General
    Replies: 5
    Last Post: 10-21-2008, 08:06 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •