Don't want to share DB anymore
Results 1 to 4 of 4
  1. #1
    Member
    Join Date
    Dec 2008
    Posts
    31

    Default Don't want to share DB anymore

    For the last 6 months or so I've been sharing my DB between my laptop and desktop using an external hard drive.

    I think my DB is pretty large now and it seems to run really slowly through the external hard drive. Also lately I've been playing 95% of my desktop.

    I'd like to just get my database to run of the internal hard drive in my desktop hopefully for more speed.

    What's the best way to revert the sharing process back to the original process? Obviously I'd like to keep all my information. Currently running postgres 8.3

    Thanks

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

    Default

    Please update to the latest beta - http://www.holdemmanager.com/downloads/HmBetaUpdate.exe

    Vista: Turn off UAC - http://www.holdemmanager.net/faq/afm....aspx?faqid=73

    Turn off Windows Firewall for installing HM and PostgreSQL. Once you get those installed you can add exceptions to the firewall. If you have a 3rd party firewall, uninstall it completely before installing HM/SQL - http://www.holdemmanager.net/faq/afm...aspx?faqid=171

    For uninstalling SQL please 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\data directory to it's new location.
    3) run the command - start > run > cmd >
    PHP Code:
    net user postgres /delete 
    4) reboot.
    5) Install the same version of PostgreSQL as your current DB using these instructions - http://www.holdemmanager.net/faq/afm...aspx?faqid=177
    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.

  3. #3
    Member
    Join Date
    Dec 2008
    Posts
    31

    Default

    Ok. I will do that. I have a 27gb data file. There's definitely a ton of hands on there I don't feel like copying over. I have some observed hands and such I don't need.

    Is there a way I can filter it out so I'm only copying over only the hands I played in?

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

    Default

    Quote Originally Posted by housenuts View Post
    Ok. I will do that. I have a 27gb data file. There's definitely a ton of hands on there I don't feel like copying over. I have some observed hands and such I don't need.

    Is there a way I can filter it out so I'm only copying over only the hands I played in?
    Make sure you have properly configured an alias for any/all screen names you have.

    http://www.holdemmanager.net/faq/afm....aspx?faqid=35


    Select that alias and then go to Options > Purge Hands:

    http://www.holdemmanager.net/faq/afm...aspx?faqid=152

    Purge all cash hands and then tourney hands that do not involve you. Make sure your alias is selected as the Do Not Delete Hands Played By: name.


    Now purge all observed hands in the same manner. You will have to do this multiple times, to get rid of all the different game types, and make sure your alias is selected each time.

    http://www.holdemmanager.net/faq/afm...aspx?faqid=107






    Now export your entire DB to text files:

    http://www.holdemmanager.net/faq/afm...aspx?faqid=173


    Create a new DB and import those exported hands, from the purged DB.

    http://www.holdemmanager.net/faq/afm...aspx?faqid=146

Similar Threads

  1. How to share a database
    By darkrem in forum Manager General
    Replies: 21
    Last Post: 12-07-2009, 03:31 AM
  2. Auto-rate (share your configs)
    By madlion in forum Share your HUD configurations
    Replies: 6
    Last Post: 09-28-2009, 05:05 AM
  3. Does anybody have any decent ipoker miniview configs they would like to share?
    By mjrgaming in forum Share your HUD configurations
    Replies: 1
    Last Post: 01-06-2009, 07:42 PM
  4. Share layout
    By GuyCarbonneau in forum Share your HUD configurations
    Replies: 6
    Last Post: 12-11-2008, 02:29 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
  •