best way to export a large database

[Juuza]

I have a pretty large (I think?) database. I don't know how many hands are in it, but there is almost 80k unique players. I'm looking to export all the hands in it, including the observed ones and save it as a backup incase something happens to my HDD.

I tried exporting it through Database Management, but the program just hanged even after I left it on for several hours. I suppose the database is too big to export this way.

What's the best way to export a large database?

[morny]

It will appear to hang even with a small amount of hands, with a big database it may take a few hours so it would be better to do this overnight and it should be ready in the morning.

You can also use this method:

http://www.holdemmanager.net/faq/afm....aspx?faqid=12 Although its not as reliable as exporting the hands

[Bloged]

This post has to a way to dump a database directly from PostGresSQL.

http://www.holdemmanager.net/forum/s...ead.php?t=5985

Grtz, Bloged

[mksmipalla]

I keep getting confused by this. Why is it not the same thing? Isn't having your HMArcive folder backed up that same as exporting the hands from the data base. Which is the better or safer way to do this. Should I be exporting my hands from the data base every so often as a back up?

[morny]

As long as youve the original HH then thats fine, some people dont keep these though so exporting is the best option in that case

[Al1]

I keep getting confused by this. Why is it not the same thing? Isn't having your HMArcive folder backed up that same as exporting the hands from the data base. Which is the better or safer way to do this. Should I be exporting my hands from the data base every so often as a back up?

No. HEM software with all his settings in stored in the "RVG Software" folder.
But HEM, like others tracker store the informations of your hands in a database. The database is another software. One of the best DB software in the world is postgreSQL and that's the one HM use.

Of course, like Morny said, you can also recreate a new postgreSQL DB from your original HHs files.

[dqmien]

Hi,

Despite your explanations I'm still confuse.

I have a huge database (20 million hands). I got 2.5 go in .txt in my Poker room folder and 15go of files in my PostgreSQL database.

I would like to give those hands to a friend so he can import them in his HEM database and use them too.

How should I proceed please.

Thanks in advance.

[morny]

You can export the hands from your database http://www.holdemmanager.net/faq/afm...aspx?faqid=173 and send them. If you were archiving your folder from the very beginning you may already have all the hands in your archive folder so you could send those either whatever is handiest

[dqmien]

OK thanks a lot for your help

One last question :

the database control panel will become greyed out and unusuable during this process which can take some time depending on the amount of hands you have

Is that normal that the status of the database control panel is "not responding" while it is exporting the HHs ?

[dqmien]

it worked.

Thanks