PDA

View Full Version : How to regularly backup my database?



custo80
08-02-2009, 07:54 PM
This is obviously a pre-emptive question but on the off chance my computer 1 day decides to pack it in and I lose everything, which has happened in the past, how do I go about backing up my entire DB and having it stored in a safe place. Further to this I would like to do it at least once per week.

I’m sure there is heaps of documentation around for this topic but if anyone could point me in the best direction for my enquiry that would be great. Also if possible to read something that is written for people that aren’t computer database wizs.

Cheers

fozzy71
08-02-2009, 08:49 PM
The biggest thing I do to backup my poker (and other important) data:

External Hard Drive, and I use AllWay Sync to synchronize copies of all my important folders and partitions on my computer. Cobian Backup is a free backup tool, that is supposed to be very good (and I should try to use some time). It runs daily if I leave my PC on, or I do it manually before rebooting. This makes synchronized backups of all my poker sites, HM folder, HH archives, PostgreSQL installation, as well as my SQL backup files I do every month.

If my PC dies right now, I have a copy of all my important programs and data, as they were at my last backup. I can reformat, reinstall everything, and use my backup copies to restore the majority of my programs's setting's and preferences. I can reinstall SQL and use my existing \data folder to restore quickly. if that fails, I have backups of my hand histories.


This is everything i would tell someone to copy/backup before uninstalling HM or postgresql.

Before you uninstall HM:

I want to re-install Holdem Manger without losing all of my settings and preferences. Can this be done? (http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=98)


How do I re-install PostgreSQL and use a previous database? (http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=177)


How do I backup and restore my database? (http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=12)


How do I export or import hands into and from Holdem Manager? (http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=173)


You want to make sure you backup your Processed/Archived hand histories, your entire \config folder, and your exportednotes file. (http://www.holdemmanager.net/faq/?f=119) I usually just copy my entire \Holdem Manager directory.

I would also make sure you manually export the database to hand history text files:

HM > Options > Database Management > Connect > Export Hands

Make sure you copy that folder as well as the other stuff I mentioned.

This helps to insure that if anything goes wrong with the backup/restore, you can manually import the exported files to rebuild.