Making a Database Backup (HEM)

RogueRivered

RogueRivered

Visionary
Silver Level
Joined
Oct 20, 2008
Total posts
957
Poker Chips
0
Casino Coins
0
  • #1
My database is getting kind of big, and I'd hate to lose it. Does anyone know how to make a backup of the HEM database to DVD?

Thanks.
 
M

maolitas

Rock Star
Silver Level
Joined
Jan 9, 2008
Total posts
179
Poker Chips
0
Casino Coins
0
  • #2
Hi,
you must connect on the database through pgAdminIII.
Right click on your database, then save.
If the file is bigger than 1 dvd, you can use Winrar, or any other tools, to split it on 2 files fitting on 1 dvd.
Just to let me know, as you have a 2 dvd database, and I'm planning to buy HEM too. Did it take a long time for your db to grow so big ?
Do you play really a lot each day?
 
Stick66

Stick66

Legend
Silver Level
Joined
Nov 10, 2005
Total posts
6,374
Poker Chips
0
Casino Coins
0
  • #3
RogueRivered said:
My database is getting kind of big, and I'd hate to lose it. Does anyone know how to make a backup of the HEM database to DVD?

Thanks.
Click to expand...
The way I do it is to backup my HH text files to an external HD. I have my Norton backup new files every couple of days overnight. If I ever need to restore, I can choose how far back I want to restore my PostGres DB by choosing how far back I want to restore.

A decent 100GB+ external HD runs around $100 or so. Might be cheaper than buying and running through packs of recordable DVD's.
 
Mase31683

Mase31683

Legend
Silver Level
Joined
Sep 27, 2008
Total posts
1,474
Awards
1
Poker Chips
1
Casino Coins
0
  • #4
I'm a huge fan of the external HD. That's my choice backup for everything
 
Stick66

Stick66

Legend
Silver Level
Joined
Nov 10, 2005
Total posts
6,374
Poker Chips
0
Casino Coins
0
  • #5
MrSticker said:
The way I do it is to backup my HH text files to an external HD. I have my Norton backup new files every couple of days overnight. If I ever need to restore, I can choose how far back I want to restore my PostGres DB by choosing how far back I want to go to import HH's.

A decent 100GB+ external HD runs around $100 or so. Might be cheaper than buying and running through packs of recordable DVD's.
Click to expand...
Oops. Fixed my post.
 
RogueRivered

RogueRivered

Visionary
Silver Level
Joined
Oct 20, 2008
Total posts
957
Poker Chips
0
Casino Coins
0
  • #6
Thanks for the advice. Yes, it makes sense to just backup the HHs. I didn't think of that. They will probably zip down pretty far, too, to save space. Then the database could be rebuilt if necessary. That sounds easier than trying to find the actual database files and archiving them.
 
BelgoSuisse

BelgoSuisse

Legend
Silver Level
Joined
Nov 26, 2007
Total posts
9,218
Poker Chips
0
Casino Coins
0
  • #7
+1 on backuping the HH. Also a better solution if you ever decide to switch to a competing solution like PT3 or some other program that could appear on the market later on.
 
Top