PDA

View Full Version : New Computer



BubbleBoy
02-20-2010, 12:35 PM
Hi guys.

So I got a new computer with the recommended components (from this thread (http://www.holdemmanager.net/forum/showthread.php?t=11194)), 2 fast hdd, quadcore, etc

Now whats the best way to move my database ?

my db is ~100gb right now.
I got ~75% of the hands as plain hh backed up.

Should I backup my db and then restore? How? Or rather create a new one and import all me backed up hands? When should I vacuum/analyze (old one before backing up, new one after restoring?)? How does my hud setup / my notes get backup up?

And how do I clean install postgre.. which version works best with w7?


Basically any tips or guides are appreciated :)

Patvs
02-20-2010, 03:00 PM
-1 On your old computer--> go to Program Files/PostgreSQL/SQL 8.x/Data/pg_log
delete the content of the pg_log folder!

Your database is still 100 GB now?

-2 Open pgAdminIII, connect to your database. Write down which SQL version you were using (8.3 or 8.4?).. click the properties of your HoldemManager database... what is the encoding (UTF8 or ASCII?)
BACKUP the database, it will create a .backup file about 1/12 the size of your database.... if during the backup pgAdminIII states "program is not responding" IGNORE that error

-3 On your NEW computer, install the same version of SQL as you created the backup in. Install HoldemManager. Create a database in HoldemManager with the same encoding. Connect to that database / start HoldemManager... click OK to all the "HoldemManager made an update to your database messages".

-4 CLOSE HoldemManager and open pgAdminIII: RESTORE the .backup file to the new database.

---

-5 Also save your original handhistories, in case the backup/restore FAILS!
If the backup/restore is successful it will have also restored your:
NOTES, BONUS/RAKEBACK settings, and ALIAS settings.

-6 On old computer--> export your HUD (HUD OPTIONS--> Player Preferencees--> Export HUD) and import that on the new computer.

(8.3 and 8.4 both work on Windows 7.. but it's key you use the same version in order for the backup/restore process to work)

BubbleBoy
02-20-2010, 03:08 PM
Thanks.

Yeah it's 100gb, I disabled/deleted the log files long ago :)
Im on v8.3.

How long is this backing and restoring gonna take? like 1 hour? 10 hours? I shouldn't interrupt it right.

If anyone else has any tips or experiences please post them.

Patvs
02-20-2010, 04:04 PM
Restore/Backup of a 100 GB database (10+ million hands?)
It all depends on the harddisk speed.

The backup can take 2-24 hours.
The restore 2-12 hours.

Though.. that's still a lot faster than reimporting your original handhistories.. which can take DAYS.

BubbleBoy
02-27-2010, 10:11 AM
Im about to install the OS...

hm works with 64bit windows 7 right? poker clients too?

morny
02-27-2010, 10:17 AM
Yes

BubbleBoy
02-27-2010, 10:53 AM
Damn I just wanted to start backing up but I get this error


C:\Programme\pgAdmin III\1.8\pg_dump.exe -h localhost -p 5432 -U postgres -F c -b -v -f "D:\HM_Aug08_backupFeb10.backup" "HM_08/08"
pg_dump: server version: 8.3.3; pg_dump version: 8.3.0
pg_dump: aborting because of version mismatch (Use the -i option to proceed anyway.)
pg_dump: *** aborted because of error

Process returned exit code 1.

whats wrong :confused:

fozzy71
02-27-2010, 03:49 PM
I don't know what is wrong but if you can still connect to the DB I would export all your hands, and anything else you can/need.


Export Your Notes
http://faq.holdemmanager.com/images/notes-02.jpg

Export Your Bonuses and Rakeback - Options > Rakeback & Bonuses
http://faq.holdemmanager.com/images/rakeback-bonuses-01.jpg

Export any tourney summaries by selecting all your tournaments in the Data View Sub-Tab of the Tourney > Results Menu and choose Export Tourney Results and summaries

http://faq.holdemmanager.com/images/tourney-data-view-01.jpg

and finally:

Export your hands and then open the new database and import them into that. You may want to break tghe exported files into smaller groups so you can import a batch overnight and use the PC the next day (and vacuum your DB, etc) - FAQ - Hold'em Manager Poker Tracking Software :: How to Import & Export Hands (http://faq.holdemmanager.com/questions/98/How+to+Import+%26+Export+Hands)

Once the Hands are imported you can import the Tourney Results and Bonuses/Rakeback

BubbleBoy
02-27-2010, 09:24 PM
If I export the hands using this window

http://1.1.1.3/bmi/faq.holdemmanager.com/images/database-management-99.jpg

how long is it gonna take and how much data is that gonna be? I got a ~100gb database but only 15gb space left on the hard drive, is that gonne be enough? should I maybe export month by month?

BubbleBoy
02-27-2010, 10:08 PM
yeah as it prompts me, this will take forever without a status bar.. what if my disk space is exceeded during the export? I cant even choose where to export to.. the drive hm is installed on is close to full, I would need to export it to some other place.

fozzy71
02-27-2010, 11:06 PM
Update to the latest version and you can pick the path to save it to.

Please update to the latest version - http://www.holdemmanager.net/hmupdate

BubbleBoy
02-27-2010, 11:32 PM
I am running the latest though I didn't update the db yet, but thats not causing the problem is it

or can I select the path after I hit yes on the promt "are you sure?"?

---> yeah it does :/

BubbleBoy
02-28-2010, 12:11 AM
any idea how big the exportet hands folder will become? ~db size? half? double? Its at 4gb now running for 30min..

BubbleBoy
02-28-2010, 02:51 AM
alright its done, 100gb database gives just 25gb hand histories in only 3hours.