Problem moving database
Results 1 to 10 of 10
  1. #1
    Junior Member
    Join Date
    Oct 2009
    Posts
    7

    Default Problem moving database

    Hello, i just had a problem moving my desktop database to my laptop cause im gonna be away for a few months, y copied de database files as sugested here: FAQ - Hold'em Manager Poker Tracking Software :: Move Database to Another Hard Drive or Partition but i have problems when im trying to initialize holdem with the new files.

    Its seems like i cannot start the service again and i got error msgs =/ please help me i can make this work and im missing a huge database of 25gb =/.

    Thx in advance.

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

    Default

    Something went wrong during your move process - restore your original configuration and move the data folder back.

    After it is running again create a backup via pgadminIII, uninstall postgresql, download and install the same postgresql version (from PostgreSQL: The world's most advanced open source database) and install it to your new partition. Create a new empty database via pgadmin and restore the backup.

  3. #3
    Junior Member
    Join Date
    Oct 2009
    Posts
    7

    Default

    Its not working =/ cannot start the service... this is what im doing:<br />
    <br />
    1.- I have a the data folder from my desktop pc.<br />
    2.- Im installing postgres and holdem manager on this laptop.<br />
    3.- Im linking postgress with the data file from my desktop as posted on the link at the first post.<br />
    4.- Rebooting pc<br />
    5.- The service wont start =/ i tried to initialize it manualy but it said it can be initiated =/.

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

    Default

    In this case the data folder and the postgresql version don't match.<br />
    <br />
    You need to run the fresh installation and restore a backup.

  5. #5
    Junior Member
    Join Date
    Oct 2009
    Posts
    7

    Default

    So i must install the same version of postgress of the data folder? how can i now the version of my data.<br />
    <br />
    And what do u mean with fresh instalation? another posgress version matching my data? and what do u mean by restoring back up? =// how can y backup my data if i cant start the server with it.

  6. #6
    Junior Member
    Join Date
    Oct 2009
    Posts
    7

    Default

    I think u got it wrong i dont have a backup of my database i have My Data folder from my old pc, how can i backup this database if i can start the service =//

  7. #7
    HM Support Patvs's Avatar
    Join Date
    Feb 2009
    Location
    Amsterdam, the Netherlands
    Posts
    33,523

    Default

    Did you use SQL 8.3.x or 8.4.x?
    You reinstalled the same version (it doesn't matter what "x" is) on your laptop?

    Can you still connect to your database on your desktop??
    Do you still have a backup of your archive folder? (if the archive folder is <10 GB the easiest solution would be fix the SQL issue, by installing a DIFFERENT version as before, and reimporting all the hands)
    Participate in the Beta release of the newest Hold'em Manager version: HM Cloud. Sign-up HERE.

    If you would like to leave some feedback to help us improve the quality of the solutions, and/or the support quality you received, - you can do this here

  8. #8
    Junior Member
    Join Date
    Oct 2009
    Posts
    7

    Default

    I was trying wit SQL 8.4 but i also tryed with SQL 8.3 (uninstaling the 8.4) but its the same, as long as i Put the old data folder ( the one from my desktop ) the service wont start. I dont have acces to my desktop pc (its like 1000 miles away ). =/ I dont know what to to i cant create a backup cause i need the service to start to do that so the only thing i Have its the DATA folder with my old and big database of 24 GB and i can make it work on this laptop.

    I can re-importa hands cause i dont have them here with me and also we are talking of nearly 3.5 million hands that would take a life to re-import so i need to make this Data folder work.

  9. #9
    HM Support Patvs's Avatar
    Join Date
    Feb 2009
    Location
    Amsterdam, the Netherlands
    Posts
    33,523

    Default

    If you start by only reimporting 2010 hands. It should only take you a couple of hours. (just let it import while you sleep) You do have all the original handhistories?

    "Move Database to Another Hard Drive or Partition" is only meant if you want to change the data folder on your computer.

    Not for moving the data folder to a DIFFERENT computer.
    For that create a .backup file in pgadminIII--> and restore the .backup file on the new computer.

    Does ANYONE have access to your old computer? A .backup should be compressed by 1:12. You can easily sent a 1-2 GB file via Skype.
    Participate in the Beta release of the newest Hold'em Manager version: HM Cloud. Sign-up HERE.

    If you would like to leave some feedback to help us improve the quality of the solutions, and/or the support quality you received, - you can do this here

  10. #10
    Junior Member
    Join Date
    Oct 2009
    Posts
    7

    Default

    Oh i see, thank you for trying =/ it seems like theres no way to make that folder works =/ i will have to try the backup function. No i dont have the hand histories with me and the 3 million hands are from just one month, I bought some datamined hands.

    Well thanks for ur time.

Similar Threads

  1. moving database+HEM to new computer
    By D.redstone in forum Manager General
    Replies: 7
    Last Post: 10-01-2012, 08:50 PM
  2. Moving a database to an external HD
    By jrholdem23 in forum Manager General
    Replies: 1
    Last Post: 08-16-2010, 05:40 AM
  3. Moving database
    By j0m0 in forum Manager General
    Replies: 1
    Last Post: 02-03-2010, 04:44 AM
  4. Have used both licenses and moving database
    By KappaKid83 in forum Manager General
    Replies: 2
    Last Post: 04-10-2009, 03:12 AM
  5. Moving Database to New PC
    By Helpme in forum Manager General
    Replies: 3
    Last Post: 10-21-2008, 03:59 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
  •