safest way to move database without losing hands?
Results 1 to 3 of 3

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Junior Member
    Join Date
    Nov 2009
    Posts
    25

    Default safest way to move database without losing hands?

    I would like to know the safest and most reliable way to transfer a database to a new computer, i feel like a lose hands with every new database move i do. (when getting import errors etc.)
    So except from having all the original hand histories and import them into a new database, what's the safest method to do this?
    Use the backup/restore inside holdem manager?
    Use the backup/restore in PG Admin (Postgresql)
    What about exporting all the hands from the database using option "export hands" and the reimport them into a new one?

    Thanks.

  2. #2
    Senior Member
    Join Date
    Aug 2008
    Posts
    381

    Default

    Exporting/re-importing the HHs will the slowest (if you have a large DB) but probably cleanest option. It would get rid of a bunch of cruft that tends to accumulate over time in a DB.

    That said, I take the lazy approach and just backup/restore the DB. You can use HEM's built-in backup/restore, but it doesn't work with PostgreSQL 9.x. I just use pgAdmin to do the DB backup/restore/maintenance. I recently upgraded to 64-bit v9.0.3 and while I can't really quantify an improvement, it seems faster to me.

  3. #3
    Moderator olliepower's Avatar
    Join Date
    Nov 2008
    Posts
    385

    Default

    Use this

    http://faq.holdemmanager.com/questio...up+%26+Restore

    If that does not work,

    you can import your C:\hmarchive

Similar Threads

  1. Move Database
    By HMaddicted in forum Manager General
    Replies: 5
    Last Post: 04-13-2010, 06:21 PM
  2. Hud + database. Move.
    By cookie in forum Manager General
    Replies: 7
    Last Post: 04-12-2010, 09:50 PM
  3. Move Database?
    By questionss in forum Manager General
    Replies: 14
    Last Post: 06-18-2009, 04:49 AM
  4. Move database from C: to E:
    By Dirkvanb in forum Manager General
    Replies: 3
    Last Post: 05-19-2009, 06:39 PM
  5. Replies: 1
    Last Post: 08-24-2008, 05:19 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
  •