literate-perfunctory
Poker Software
Results 1 to 4 of 4
  1. #1
    Member
    Join Date
    Sep 2008
    Posts
    86

    Default If I use the backup and restore function, how big will the backup file be?

    Alright, so I have a 430gb HEM database, and im looking to move this to another harddrive without having to spend the time to re-import all the hands manually. If I was to use the backup/restore function within HEM, i'm assuming it creates a single backup file for the database correct?

    If so, how big would this backup file be in relation to the size of my database?

    Also, what would happen if my computer was to randomly reboot while using the backup/restore function to backup a HEM database?

    Lastly, how long would creating the backup file take?
    Last edited by Eclipse86; 10-19-2010 at 03:15 AM.

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

    Default

    430 GB database - i can't believe this. How did you calculate this?

    How many hands do you have in your database? FAQ - Hold'em Manager Poker Tracking Software :: Check Total Amount of Hands in Database


    If its really 430 GB i would estimate the backup file has about 50-100 GB.

    The backup and restore will at least last some hours but this is hard to say because it depends on many factors.
    To be on the safe side you should reserve 2 days for the backup / restore process.

  3. #3
    Member
    Join Date
    Sep 2008
    Posts
    86

    Default

    I have 2 databases on this comp, one is a PT3 db with only my played hands on it (about 1.2 million) and the other is my HEM db with all my played hands in it plus all my datamined hands. In the Postgresql/8.3/data/base folder there's several different folders in there, one is 10gb which i assume is the smaller PT3 db, and the other is 430gb which i assume is the HEM db.

    The total amount of hands in my HEM db is a bit over 113m hands. I import an avg of about 300k datamined hands/day and have been doing so for the last 12 months, which is why the db is so big.

    fwiw, running the query to check the amount of hands took a bit over 10 mins lol.

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

    Default

    Wow, you should really start purging old hands.

    In general you can delete the mined hands after the import as you only need the stats. I would at least purge all hands older than 2 month which you didn't play.
    But i don't think the purge will work in one run. You should start deleting hands older than 12 month or something like that.

    FAQ - Hold'em Manager Poker Tracking Software :: Holdem Manager Performance & Speed Tweaks

Similar Threads

  1. Backup/Restore
    By deejaypee in forum Manager General
    Replies: 5
    Last Post: 09-28-2010, 01:46 PM
  2. Backup/Restore function
    By un1bomber in forum Manager General
    Replies: 1
    Last Post: 08-31-2010, 02:16 AM
  3. does "backup & restore" backup notes on players?
    By crypkilla in forum Manager General
    Replies: 2
    Last Post: 07-02-2010, 07:06 AM
  4. Backup & restore function missing from file menu?
    By bogo in forum Manager General
    Replies: 1
    Last Post: 05-18-2010, 04:05 AM
  5. Restoring DB without using the backup/restore function?
    By scar3face in forum Manager General
    Replies: 0
    Last Post: 05-13-2010, 06:46 AM

Posting Permissions

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