View Full Version : can anybody help w hand/note retrieval? willing to pay
praetor
05-18-2010, 10:34 PM
Having a problem w old Database, I grabbed the folder from a dead harddrive but cant access the DB or extract my notes
Was told that posting over here is best chance of finding someone able to help
Willing to pay for time
Cheers
Sarek
05-21-2010, 08:02 AM
I did it - it works
* start - programs - postgresql - pgadmin
* dbl-click on server (enter password) and find your DB
* expand to schemas - public - tables and find table named "hemplayernotes"
* right-click - Scriprts - SELECT script
* delete all text and type (or copy/paste) this
SELECT p.playername, p.site_id, n.note, n.icon_id
FROM hemplayernotes n, players p where n.player_id = p.player_id;
* press F5
* File - export - set there: Row separator = CR/LF, No qouting, charset = UTF8, column separator to "|"
* save file as CSV = you have extracted notes
* but now you need to format them exactly as in HM exported file - change separator and some, delete headers etc
should I explain this steps too, or you can do it without help?
praetor
05-21-2010, 06:42 PM
I mean, once I go thru that, into PG admin and databases, my old database isnt even there. I guess its not "linked" to Postgres on this computer or something? Its just my entire old HM folder sitting on my HD and I dont know what to do with it?
Sarek
05-22-2010, 05:38 AM
I grabbed the folder from a dead harddrive
Cheers
datavase lives in folder postgresql\data
do you have access to this "old" folder?
if no - no ways to extract notes from old base
praetor
05-22-2010, 05:39 AM
Oh. I naively assumed the database would be in the HM folder. Dont think so.
damn, thanks
a.k.a.Also
06-22-2010, 03:05 PM
I did it - it works
* start - programs - postgresql - pgadmin
* dbl-click on server (enter password) and find your DB
* expand to schemas - public - tables and find table named "hemplayernotes"
* right-click - Scriprts - SELECT script
* delete all text and type (or copy/paste) this
SELECT p.playername, p.site_id, n.note, n.icon_id
FROM hemplayernotes n, players p where n.player_id = p.player_id;
* press F5
* File - export - set there: Row separator = CR/LF, No qouting, charset = UTF8, column separator to "|"
* save file as CSV = you have extracted notes
* but now you need to format them exactly as in HM exported file - change separator and some, delete headers etc
should I explain this steps too, or you can do it without help?
Finally got round to trying this.
Changed to
4319
for the export settings, and it opened up nicely in a spreadsheet.
Thanks!
Powered by vBulletin® Version 4.2.3 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.