Page 1 of 1

Restoring a database without a proper backup?

PostPosted: Thu Sep 30, 2010 10:37 pm
by jackdninja
Hi all.

I recently reformatted my computer (running off of 1 harddisk) and I actually backed up the complete drive to USB but I forgot to backup the sql database from pokertracker.

I looked around and it seems like if you want to import another database you have to back it up. Unfortunately this is not an option for me. Are there some files I can copy from my backup to the fresh new SQL folders that would restore my old database?

Thanks,
Jack

Re: Restoring a database without a proper backup?

PostPosted: Fri Oct 01, 2010 2:34 am
by WhiteRider
Please read this thread which is about the same sort of issue.

Re: Restoring a database without a proper backup?

PostPosted: Fri Oct 01, 2010 2:26 pm
by jackdninja
Thanks, I tried the first thing (moving over the 8.3 folders) but it couldn't connect. After work I'm going to try the reinstalling of SQL. I'll update later!

Re: Restoring a database without a proper backup?

PostPosted: Fri Oct 01, 2010 3:00 pm
by kraada
Good luck - keep me posted!

Re: Restoring a database without a proper backup?

PostPosted: Wed Oct 06, 2010 2:13 am
by jackdninja
So I've been messing around with my databases and I uninstalled SQL and reinstalled and I cannot get it to connect to the backed up server.

When I try from the installer it says my username/password is wrong.

When I try from pokertracker I get a popup window "Configure postgreSQL Database" and when i try to browse databases I get:

"
Unable to login to database (template1). Reason: could not connect to server: Connectin refused (0x0000274D/10061). Is this server running on host "???" and accepting TCP/IP connections on port 5432?
"

I'm trying the default postgres / dbpass combo and no luck. Maybe in my stupidity 2 or so years ago (when I first made the DB) I changed the username or pass and forgot to write it down =(.

Does this mean I'm screwed?

Re: Restoring a database without a proper backup?

PostPosted: Wed Oct 06, 2010 9:16 am
by kraada
Not if the server is actually running. Click Start, type Services.msc and hit enter. Locate PostgreSQL from the list, is the server running? If not, does it start?