I have some datamined hands in my database that I do not want anymore. How can I delete them from my database completely including player names?
I have some datamined hands in my database that I do not want anymore. How can I delete them from my database completely including player names?
I have some tournament (sng's at ongame) hands in my cash games section, should I delete them some how or is there coming some fix that makes them go away? I have the latest beta downloaded.
- purge old database
- vaccum/analyze thru PGAdmin
- export your hands from database control panel
- create new database and set as default
- manualy import to new DB from folder > C:\Program Files\RVG Software\Holdem Manager\HandHistoryExport_NameOfDatabase
Later, after you know your new DB is accurate, and working properly, you can go thru PGAdmin to Delete/Drop the previous/purged DB. After all that purging and deleting it would be wise to defrag your hard drive ((Defraggler). Make sure you Stop the PostgreSQL service before defragging, and ReStart the service after, or reboot completely.
You have 1.09 beta 8??Originally Posted by hara_x
Filter the Hands tab so you can see those hands, then right-click delete them. Then try importing them again.
I have tried this on my old computer to no apparent luck. However it was a royal peice of crap so something may have just went wrong.
On my new computer I have tried purging all hands I was not involved with through the observed hand history config and it claims it deleted all the hands, then did a full/analyze vacuume through pgadmin, then exported hands and got close to the same amount of files in my export. I did not try reimporting them in a new database however as I thought they may have still been in there. Will there still be close to the same amount of files in the export folder after I deleted all of the hands? I only have 30k hands I want to keep.
Is there any diffrence between the direct purge hands feature and the purge hands feature available in the observed hand feature?
I will try again when I get home this afternoon.
Yes, all of the purged hand files should be blank or empty now. During the purge process it gives a running total of hands purged and hands skipped due to player filter. I had never purged my DB (LOL) and I just did it after answering your post. I still have the same number of text files. I plan to create a new DB and import them later today. After I have them imported I plan on running some sql queries to get the total hand count from each db to hopefully see the difference. I will try and report back my findings in this thread.
I think the purge hands button in the observed hand history config window do the same job. The one just has a couple of different ways to filter I think.
Thanks. When I get home I will try importing my exported folder in a new database and will let you know as well. Thanks for the help as usual Fozzy.
Last edited by #1ThunderFan; 06-23-2009 at 11:50 AM.
that helped, ty
I have sent an urgent email to fabio so he can address your issue.
Please make a new thread so we can try to help you.
Were you instaling SQL to the default install path (C:\Program Files\PostgreSQL\?
Can you go to Start > My Computer > Right-Click + Properties on the Local Disk (Cand tell me if the File System: is NTFS
You can just answer those questions in the new thread if you want.
yw
Posting Permissions
