PDA

View Full Version : New computer but have a big db on my old comp.



pokerabc123
07-30-2009, 02:51 PM
I just bought a new computer, the problem is that i have a big database on my old computer that i want to move to my new computer.

My db is around 5 mill hands whats the easiest way to solve this problem.

I really would like to have all the settings saved as well such as hud settings etc.

Is it possible to do this fast and easy?

netsrak
07-30-2009, 04:58 PM
Backup and restore your database: http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=12 this will take some hours

For security: export all your hands and save them in a safe place: http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=173
For the rest see this: http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=101

pokerabc123
07-30-2009, 08:49 PM
how long time do you think this will take? more than 12h?

is this the easiest solution?

and when i have backuped my db, how do i transfer it all the easiest way to my new comp?

fozzy71
07-30-2009, 10:55 PM
It could take a few hours using the backup/restore process. The easiest method is to export and import the hand files, but that is the slowest process. The Bup/Restore compresses the data a lot.

The fastest method is to copy your entire /data folder and install SQL over it on the new machine, making sure you dont initialize the DB cluster so it will use your old DB. This will probably require an external HD as your \data folder is probably pretty big. The backup file should be able to fit on a thumb drive or CD/DVD.

The \config\prefs.xml file contains all your HUD settings and configs.

Leif
07-31-2009, 07:05 AM
"
copy your entire /data folder and install SQL over it
"

How do you do that ?

fozzy71
07-31-2009, 07:47 AM
"
copy your entire /data folder and install SQL over it
"

How do you do that ?

http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=177

pokerabc123
07-31-2009, 12:07 PM
It could take a few hours using the backup/restore process. The easiest method is to export and import the hand files, but that is the slowest process. The Bup/Restore compresses the data a lot.

The fastest method is to copy your entire /data folder and install SQL over it on the new machine, making sure you dont initialize the DB cluster so it will use your old DB. This will probably require an external HD as your \data folder is probably pretty big. The backup file should be able to fit on a thumb drive or CD/DVD.

The \config\prefs.xml file contains all your HUD settings and configs.

Well i dont know computers so well do u think this product will do the job? Freecom MobileDrive XXS 320GB / USB 2.0 / 5400rpm, costs around 100usd.

If so, then i copy my data file which is around 30gb, into this disk, download and install sql on my new comp and dl and install hm.

how do i work from here do you have simple step by step list for someone like me? :)

then the config file how do i import that to hm again.

Please give me somekind of simple step by step guide and how long do you think this will take?

thanks

fozzy71
07-31-2009, 12:19 PM
Well i dont know computers so well do u think this product will do the job? Freecom MobileDrive XXS 320GB / USB 2.0 / 5400rpm, costs around 100usd.

That will be more than sufficient.


If so, then i copy my data file which is around 30gb, into this disk, download and install sql on my new comp and dl and install hm.

how do i work from here do you have simple step by step list for someone like me? :)

then the config file how do i import that to hm again.

Please give me somekind of simple step by step guide and how long do you think this will take?

thanks

On your new PC:

Start > My Computer > Go to C:\Program Files:

Right-Click in an empty space > New > Folder: Name it PostgreSQL

Go into that new folder, and create another new folder, named: 8.3

Find the \data folder on your external HD > Right-Click on \data and choose Copy

Now click in the empty space within the \8.3 folder, and Right-Click > Paste the \data folder to your new PC.


Now follow the FAQ I linked previously for installing SQL with a previous DB.

Make sure you turn off thw Initialize DB Cluster as directed in the FAQ.

http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=177


If you are going from XP to XP or Vista to Vista, you can copy your entire \config folder from your old PC to the new one, once HM is installed. If you are going from XP to Vista, you will only want to copy the \config\prefs.xml file for your HUD settings. The settings in teh holdemmanager.config file will be noticeably different on Vista, for the Import Folders, and similar settings.

netsrak
07-31-2009, 12:20 PM
we already posted you the step-by-step guides